www.buildautomator.com  Build Automator Documentation

Date formats

Previous  Top  Next  


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



Direct link to this page: http://www.buildautomator.com/onlinemanual/date_formats.htm