Formats for DateFormat and DateTimeFormat
If you are not configuring Unica Campaign for multiple locales, you can set the values for DateFormat and DateTimeFormatconfiguration parameters for any of the formats specified in the DATE macro, as described in this section.
However, if you need to configureUnica Campaign for multiple locales (if you have users with various languages and locales), DO NOT use date formats that contain 3-letter months (MMM), %b (abbreviated month name), or %B (full month name). Instead, use a delimited or fixed format that has a numeric value for the month. For more details about the multi-locale feature, see About the multi-locale feature.
Format |
Description |
Example(s) |
|---|---|---|
MM |
2-digit month |
01, 02, 03, ..., 12 |
MMDD |
2-digit month and 2-digit day |
March 31 is 0331 |
MMDDYY |
2-digit month, 2-digit day, and 2-digit year |
March 31, 1970 is 033170 |
MMDDYYYY |
2-digit month, 2-digit day, and 4-digit year |
March 31, 1970 is 03311970 |
DELIM_M_D For DateTimeFormat, use DT_DELIM_M_D |
Any delimited month followed by day |
March 31, 3/31, or 03-31 |
DELIM_M_D_Y For DateTimeFormat, use DT_DELIM_M_D_Y |
Any delimited month, day, and year |
March 31, 1970 or 3/31/70 |
DELIM_Y_M For DateTimeFormat, use DT_DELIM_Y_M |
Any delimited year followed by month |
1970 March, 70-3, 1970/3 |
DELIM_Y_M_D For DateTimeFormat, use DT_DELIM_Y_M_D |
Any delimited year, month, and day |
1970 Mar 31 or 70/3/31 |
YYMMM |
2-digit year and 3-letter month |
70MAR |
YYMMMDD |
2-digit year, 3-letter month, and 2-digit day |
70MAR31 |
YY |
2-digit year |
70 |
YYMM |
2-digit year and 2-digit month |
7003 |
YYMMDD |
2-digit year, 2-digit month, and 2-digit day |
700331 |
YYYYMMM |
4-digit year and 3-letter month |
1970MAR |
YYYYMMMDD |
4-digit year, 3-letter month, and 2-digit day |
1970MAR31 |
YYYY |
4-digit year |
1970 |
YYYYMM |
4-digit year and 2-digit month |
197003 |
YYYYMMDD |
4-digit year, 2-digit month, and 2-digit day |
19700331 |
DELIM_M_Y For DateTimeFormat, use DT_DELIM_M_Y |
Any delimited month followed by year |
3-70, 3/70, Mar 70, March 1970 |
DELIM_D_M For DateTimeFormat, use DT_DELIM_D_M |
Any delimited day followed by month |
31-3, 31/3, 31 March |
DELIM_D_M_Y For DateTimeFormat, use DT_DELIM_D_M_Y |
Any delimited day, month, and year |
31-MAR-70, 31/3/1970, 31 03 70 |
DD |
2-digit day |
31 |
DDMMM |
2-digit day and 3-letter month |
31MAR |
DDMMMYY |
2-digit day, 3-letter month, and 2-digit year |
31MAR70 |
DDMMMYYYY |
2-digit day, 3-letter month, and 4-digit year |
31MAR1970 |
DDMM |
2-digit day and 2-digit month |
3103 |
DDMMYY |
2-digit day, 2-digit month, and 2-digit year |
310370 |
DDMMYYYY |
2-digit day, 2-digit month, and 4-digit year |
31031970 |
MMYY |
2-digit month and 2-digit year |
0370 |
MMYYYY |
2-digit month and 4-digit year |
031970 |
MMM |
3-letter month |
MAR |
MMMDD |
3-letter month and 2-digit day |
MAR31 |
MMMDDYY |
3-letter month, 2-digit day, and 2-digit year |
MAR3170 |
MMMDDYYYY |
3-letter month, 2-digit day, and 4-digit year |
MAR311970 |
MMMYY |
3-letter month and 2-digit year |
MAR70 |
MMMYYYY |
3-letter month and 4-digit year |
MAR1970 |
MONTH |
Month of the year |
January, February, March, and so on or Jan, Feb, Mar, and so on |
WEEKDAY |
Day of the week |
Sunday, Monday, Tuesday, and so on (Sunday = 0) |
WKD |
Abbreviated day of the week |
Sun, Mon, Tues, and so on (Sun = 0) |