Date Formats

Administration > File Importing >

Date format Tokens

Token
Description

Example

d The day of the month, from 1 through 31.
1/10/2014
21/10/2014

dd The day of the month, from 01 through 31.
01/10/2014
21/10/2014

M The month, from 1 through 12.
1/1/2014
1/11/2014

MM The month, from 01 through 12.
1/01/2014
1/11/2014

y The year, from 0 to 99.
1/1/14

yy The year, from 00 to 99.
1/1/14

yyyy The year as a four-digit number.
1/1/2014

BACSDATE ddYYY format. As used in standard 18 files.
14001

Note: Tokens are case sensitive

Examples

Date in file
Token

1/1/2014
d/M/yyyy

17/04/14
dd/MM/yy

17-04-14
dd-MM-yy

03/21/2014
MM/dd/yyyy (US Format)

010414
ddMMyy

Token	Description	Example
d	The day of the month, from 1 through 31.	1/10/2014 21/10/2014
dd	The day of the month, from 01 through 31.	01/10/2014 21/10/2014
M	The month, from 1 through 12.	1/1/2014 1/11/2014
MM	The month, from 01 through 12.	1/01/2014 1/11/2014
y	The year, from 0 to 99.	1/1/14
yy	The year, from 00 to 99.	1/1/14
yyyy	The year as a four-digit number.	1/1/2014
BACSDATE	ddYYY format. As used in standard 18 files.	14001

Date in file	Token
1/1/2014	d/M/yyyy
17/04/14	dd/MM/yy
17-04-14	dd-MM-yy
03/21/2014	MM/dd/yyyy (US Format)
010414	ddMMyy