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: Emperor’s 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 max. 2 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