These formatting tokens can be used to specify the format of date time categories in the Grid and the form. The strings can be entered into the Grid Display Format for the category. (See the section in the Grid Configuration.)
Note that the format of the date in the top menu area is defined by the format of the special logdatetime category. I.e. to set this format, you must set the format of the logdatetime category (using the formatting options below.)
Note that the value of a date time object is defaulted to the current time when the date first appears in a new form. From here, it can be changed if the user has the correct authorization.
Directive Meaning Notes
%a Locale's abbreviated weekday name.
%A Locale's full weekday name.
%b Locale's abbreviated month name.
%B Locale's full month name.
%c Locale's appropriate date and time representation.
%d Day of the month as a decimal number [01,31].
%H Hour (24-hour clock) as a decimal number [00,23].
%I Hour (12-hour clock) as a decimal number [01,12]. To be unambiguous, you must use the %p option with this specification. I.e. %I:%M %p
%j Day of the year as a decimal number [001,366].
%m Month as a decimal number [01,12].
%M Minute as a decimal number [00,59].
%p Locale's equivalent of either AM or PM.
%S Second as a decimal number [00,61]. (1)
%U Week number of the year (Sunday as the first day of the week) as a decimal number [00,53]. All days in a new year preceding the first Sunday are considered to be in week 0.
%w Weekday as a decimal number [0(Sunday),6].
%W Week number of the year (Monday as the first day of the week) as a decimal number [00,53]. All days in a new year preceding the first Monday are considered to be in week 0.
%x Locale's appropriate date representation.
%X Locale's appropriate time representation.
%y Year without century as a decimal number [00,99].
%Y Year with century as a decimal number.
%Z Time zone name (no characters if no time zone exists).
%% A literal "%" character.
Notes:
(1) The range really is 0 to 61; this accounts for leap seconds and the (very rare) double leap seconds.