PowerBuilder Format Datetime – PowerBuilder Library

In PowerBuilder, you can use a variety of format strings to display date values as strings. Here’s a list of commonly used format strings:

“MM/dd/yyyy”: Displays the month, day, and year in the format “mm/dd/yyyy”, with leading zeros for single-digit months and days.
“dd/MM/yyyy”: Displays the day, month, and year in the format “dd/mm/yyyy”, with leading zeros for single-digit days and months.
“yyyy-MM-dd”: Displays the year, month, and day in the format “yyyy-mm-dd”.
“MM/dd/yyyy hh:mm:ss tt”: Displays the month, day, year, and time in the format “mm/dd/yyyy hh:mm:ss AM/PM”, with leading zeros for single-digit months, days, hours, minutes, and seconds.
“MMM dd, yyyy”: Displays the month name, day, and year in the format “MMM dd, yyyy”.
“MMMM dd, yyyy”: Displays the full month name, day, and year in the format “MMMM dd, yyyy”.
“dd-MMM-yyyy”: Displays the day, month abbreviation, and year in the format “dd-MMM-yyyy”.
“yyyy/MM/dd”: Displays the year, month, and day in the format “yyyy/mm/dd”.

These are just a few examples of the many format strings you can use to display date values as strings. You can adjust the format string to display the date in different formats, depending on your needs.

You can use the String() function to convert a date value to a string. Here’s an example:

// Declare a date variable
date ld_myDate

// Assign a value to the date variable
ld_myDate = Date(2023, 3, 17)

// Convert the date variable to a string
string ls_dateString
ls_dateString = String(ld_myDate, "MM/dd/yyyy")

// Display the string value
MessageBox("Date as string", ls_dateString)

// Declare a date variable

date ld_myDate

// Assign a value to the date variable

ld_myDate = Date(2023, 3, 17)

// Convert the date variable to a string

string ls_dateString

ls_dateString = String(ld_myDate, "MM/dd/yyyy")

// Display the string value

MessageBox("Date as string", ls_dateString)

// Declare a date variable
date ld_myDate

// Assign a value to the date variable
ld_myDate = Date(2023, 3, 17)

// Format the date as "MM/dd/yyyy"
string ls_dateString1
ls_dateString1 = String(ld_myDate, "MM/dd/yyyy")

// Format the date as "dd-MMM-yyyy"
string ls_dateString2
ls_dateString2 = String(ld_myDate, "dd-MMM-yyyy")

// Format the date as "yyyy/MM/dd"
string ls_dateString3
ls_dateString3 = String(ld_myDate, "yyyy/MM/dd")

// Display the formatted strings
MessageBox("Formatted date 1", ls_dateString1)
MessageBox("Formatted date 2", ls_dateString2)
MessageBox("Formatted date 3", ls_dateString3)

// Declare a date variable

date ld_myDate

// Assign a value to the date variable

ld_myDate = Date(2023, 3, 17)

// Format the date as "MM/dd/yyyy"

string ls_dateString1

ls_dateString1 = String(ld_myDate, "MM/dd/yyyy")

// Format the date as "dd-MMM-yyyy"

string ls_dateString2

ls_dateString2 = String(ld_myDate, "dd-MMM-yyyy")

// Format the date as "yyyy/MM/dd"

string ls_dateString3

ls_dateString3 = String(ld_myDate, "yyyy/MM/dd")

// Display the formatted strings

MessageBox("Formatted date 1", ls_dateString1)

MessageBox("Formatted date 2", ls_dateString2)

MessageBox("Formatted date 3", ls_dateString3)

you can use the Date() function to convert a string value to a date. Here’s an example:

// Declare a string variable
string ls_dateString

// Assign a value to the string variable
ls_dateString = "03/17/2023"

// Convert the string to a date
date ld_myDate
ld_myDate = Date(ls_dateString, "MM/dd/yyyy")

// Display the date value
MessageBox("String as date", String(ld_myDate))

// Declare a string variable

string ls_dateString

// Assign a value to the string variable

ls_dateString = "03/17/2023"

// Convert the string to a date

date ld_myDate

ld_myDate = Date(ls_dateString, "MM/dd/yyyy")

// Display the date value

MessageBox("String as date", String(ld_myDate))

Good Luck!

PowerBuilder Tips & Tricks

PB PowerBuilder PowerBuilder Example PowerBuilder Function PowerBuilder Tips PowerBuilder Tricks PowerScript Tips & Tricks

March 17, 2023

Was this article helpful?