Try OpenEdge Now
skip to main content
Online Help
Introducing the ABL GUI Designer : Reference : GUI Designer dialogs : AppBuilder dialogs : Other AppBuilder dialogs : Formatting a Date Time-Tz field
 
Formatting a Date Time-Tz field
The Format dialog helps you to format the selected Date Time-Tz field.
You can access this dialog by clicking Format Help in the Column Editor dialog (for Browse).
The Format dialog for Date Time-Tz field includes the following options:
Format
Enter a valid display format for the selected Date Time-Tz field.
99/99/99
Select to display the date portion of the Date Time-Tz field. in two-byte segments delimited by a backslash (/). This is the standard format.
99-99-99
Select to display the date portion of the Date Time-Tz field in two-byte segments delimited by a hyphen (-).
99.99.99
Select to display the date portion of the Date Time-Tz field in two-byte segments delimited by a period (.).
99/99/9999
Select to display the date portion of the Date Time-Tz field in two-byte segments for the month and day and display the year in four-bytes. Delimit with a backslash (/).
99-99-9999
Select to display the date portion of the Date Time-Tz field in two-byte segments for the month and day and display the year in four-bytes. Delimit with a hyphen (-).
99.99.9999
Select to display the date portion of the Date Time-Tz field in two-byte segments for the month and day and display the year in four-bytes. Delimit with a period (.).
999999
Select to display the date portion of the Date Time-Tz field in six bytes with no delimiter character.
99999999
Select to display the date portion of the Date Time-Tz field in eight bytes with no delimiter character.
Include Time
Select this option when you want to include the time portion in the format.
Time Format
Specify a time format. The option you select determines how the time portion of the format appears. You can select:
*HH - Displays only the hour.
*HH:MM - Displays the hour and minutes.
*HH:MM:SS - Displays the hours, minutes, and seconds.
Note: These options are only available when you select Include time.
Decimal Places for Seconds
Select the number of decimal places you want for the second’s portion of the time format. You can select 0, 1, 2, or, 3.
Note: These options are only available when you select Include time.
12 hour format (AM/PM)
Select to specify a 12 hour time format. When you select this format hours are displayed using AM or PM.
Include Time Zone
Select when you want to include a time zone in the format.
Standard
Select to format the selected field to the default ABL DateTime-Tz format: 99/99/9999 HH:MM:SS.SSS+HH:MM.