|
|
Dates
Syntax: @Dn [s] [B]
All date formats start with @D or @d
The n determines the date format and ranges from 1 to 18.
The s is an optional separation character between year, month and days. It is forward slash (/) by default. Valid characters for s are:
. (period) produces periods.
` (grave accent - ASCII 96) produces commas.
- (hyphen) produces hyphens.
_ (underscore) produces spaces.
The trailing B will produce a Blank string if the date is empty instead of something like " / / " for @d1 for example.
Token |
Format |
Results |
@D1 |
mm/dd/yy |
10/31/59 |
@D01 |
mm/dd/yy |
01/01/59 |
@D2 |
mm/dd/yyyy |
10/31/1959 |
@D3 |
mmm dd,yyyy |
OCT 31,1959 |
@D4 |
mmmmmmmmm dd, yyyy |
October 31, 1959 |
@D5 |
dd/mm/yy |
31/10/59 |
@D6 |
dd/mm/yyyy |
31/10/1959 |
@D7 |
dd mmm yy |
31-Oct-59 |
@D8 |
dd mmm yyyy |
31 OCT 1959 |
@D9 |
yy/mm/dd |
59/10/31 |
@D10 |
yyyy/mm/dd |
1959/10/31 |
@D11 |
yymmdd |
591031 |
@D12 |
yyyymmdd |
19591031 |
@D13 |
mm/yy |
10/59 |
@D14 |
mm/yyyy |
10/1959 |
@D15 |
yy/mm |
59/10 |
@D16 |
yyyy/mm |
1959/10 |
@D17 |
|
Standard Short Date |
@D18 |
|
Standard Long Date |
|
Alternate separators |
|
@D1. |
mm.dd.yy |
Period separator |
@D2- |
mm-dd-yyyy |
Dash separator |
@D5_ |
dd mm yy |
Underscore produces space separator |
@D6` |
dd,mm,yyyy |
Grave accent produces comma separator |