You are here: Field Rules Reference > Field Rules Summary > DateFmt

DateFmt

Note

You should use the FmtDate, instead of this rule. This rule is included in this version of the system only for legacy system support.

Use this field level rule to format a date retrieved from an extract record based on the mask you select. A list of date masks appears below. This rule supports overflow.

Date masks

ID	Source	Destination	Also supported by FmtDate
1	YYMMDD	MMDDYY	yes
2	YYYYMMDD	MMDDYYYY	yes
3	YYYYMMDD	MMDDYY	yes
4	YYMMDD	MM-DD-YY	yes
5	YYMMDD	MM/DD/YY	yes
6	YYYYMMDD	MM-DD-YY	yes
7	YYYYMMDD	MM/DD/YY	yes
8	MMDDYY	MM-DD-YY	yes
9	MMDDYY	MM/DD/YY	yes
10	YYYMMDD	MM/DD/YY	yes
11	MMDDYYYY	Month D, YYYY	yes
12	MMDDYYYY	Mon D, YYYY	no
13	MMDDYYYY	MONTH D, YYYY	no
14	YYYY-MM-DD	Month D, YYYY	yes
15	YYYY-MM-DD	Mon D, YYYY	no
16	YYYY-MM-DD	MM/DD/YY	yes
17	DD/MM/YY	Mon D, YYYY	no
18	DD/MM/YY	Month D, YYYY	yes
19	DD/MM/YY	MM/DD/YY	yes
21	YYYY-MM-DD	Month DD, YYYY	no
22	DD/MM/YY	Month DD, YYYY	no
23	MM/DD/YY	Month DD, YYYY	no
24	YYMM	MM/YY	no
25	MM/DDYY	Month DD, YYYY	no
26	DD/MM/YY	Mon DD, YYYY	yes
27	YYYY-MM-DD	MM/DD/YYYY	yes

Destination formats with a single letter, such as D, indicate that the system will omit leading zeros or spaces. Also, please note that Month indicates both upper- and lowercase letters will be used while MONTH indicates only uppercase letters will be used. Mon indicates the month will be abbreviated, in upper- and lowercase letters.

DateFmt

Date masks

See also