Contents
- Index
Date formats in imported/exported files:
DD/MM/YY 2 digits for day, month and year
Eg: 25/07/99 (July 25, 1999)
MM/DD/YY 2 digits for month, day and year
Eg: 03/21/01 (Mar 21, 2001)
YYYYMMDD 4 digits for year and 2 digits for month and day
Eg: 20010415 (Apr 15, 2001)
YYYY-MM-DD 4 digits for year and 2 digits for month and day separated by dashes
Eg: 2004-05-27 (May 27, 2004)
mmm dd, YYYY Month name, day, comma then 4 digit year
Eg: Jan 1, 2003
mmm dd/YYYY Same as above with '/' between day and year
Eg: Feb 6/2003
mmm dd YYYY Same as above with space between day and year
Eg: June 8 2003
dd mmm YYYY Day, month name then 4 digit year
Eg: 31 Dec 1998