Dialog Box=>Edit Time/Date Format

The dialog can be used to create, edit or change the date/time format.

../../_images/DialogBoxEditTimeDateFormat-en.png

The formatting codes for a format string are listed below:

Value Meaning
%a Abbreviated weekday name
%A Full weekday name
%B Full month name
%c Date and time representation appropriate for locale
%d Day of month as decimal number (01 to 31)
%H Hour in 24-hour format (00 to 23)
%I Hour in 12-hour format (01 to 12)
%j Day of year as decimal number (001 to 366)
%m Month as decimal number (01 to 12)
%M Minute as decimal number (00 to 59)
%p Current locale’s A.M./P.M. indicator for 12-hour clock
%S Second as decimal number (00 to 59)
%U Week of year as decimal number, with Sunday as first day of week (00 to 51)
%w Weekday as decimal number (0 to 6; Sunday is 0)
%W Week of year as decimal number, with Monday as first day of week (00 to 51)
%x Date representation for current locale
%X Time representation for current locale
%y Year without century, as decimal number (00 to 99)
%Y Year with century, as decimal number
%z, %Z Time-zone name or abbreviation
%% Percent sign
# Remove leading zeros (if any) Example: %#m

id-2074082