Purpose:
Converts a date, using a format string, into an appropriately formatted string.
Composition of the format string: this is a normal string into which placeholders can be embedded.
Place holder |
Description |
%d |
Day (1..31) |
%<n>d |
Day to <n> digits |
%0<n>d |
Day to <n> digits, filled on left with '0's |
%w |
Weekday (1..7) |
%<n>w |
Weekday to <n> digits |
%0<n>w |
Weekday to <n> digits, filled on left with '0's |
%W |
Week of year |
%<n>W |
Week of year to <n> digits |
%0<n>W |
Week of year to <n> digits, filled on left with '0's |
%m |
Month (1..12) |
%<n>m |
Month to <n> digits |
%0<n>m |
Month to <n> digits, filled on left with '0's |
%y |
Year |
%<n>y |
Year, to <n> digits |
%0<n>y |
Year, to <n> digits, filled on left with '0's |
%q |
Quarter |
%D |
Weekday, written out |
%M |
Month, written out |
"%e", "%<n>e" |
Year in the local calendar (Japan: Emperor's year) |
"%g", "%<n>g" |
Era of the local calendar (Japan: Emperors era) |
"%g", "%1g" |
Single letter, Latin letters |
"%gg", "%2g" |
Single letter, localized |
"%ggg", "%3g" |
Long name, localized |
"%gggg", "%4g" |
Long name, Latin letters |
"%x" |
Localized date, short form |
%H |
Hours in 24h-format |
%h |
Hours in 12h-format |
%<n>h |
Hours in <n> digits |
%i |
Minutes |
%<n>i |
Minutes in <n> digits |
%s |
Seconds |
%<n>s |
Seconds in <n> digits |
%PM |
AM or PM |
As long as one of the above formats is used, the optional third parameter can be used to set the locale. If the second parameter contains a valid ISO 3166-Country code, the third parameter can be used to set either the short "0 or long "1 format.
Parameter:
Date Value to be formatted.
String (optional) Format description or ISO 3166-Country code.
String (optional) ISO 3166-Country code or date format.
Return value:
String
Example:
Date$(Today(),"%D, %d/%m/%y") Result: Thursday, 8/11/2015
Date$(Today(),"%2WthWeek; %D, %2d/%2m/%4y") Result: 45th Week, Thursday, 8/11/2015
Date$(Today(),"%D, %3d/%02m/%4y") Result: Thursday, 8/11/2015
Date$ (Now(),"%02h:%02i:%02s %PM") Result: 04:03:50 PM