Date Formats

Use date formats to specify how date values are formatted in a Date field RRT.

Date type Description Examples
Device Short Date Short date pattern using the device language setting.

12/31/2012 (en-US)

31/12/2012 (fr-FR)

31/12/2012 (es-ES)

Device Long Date Long date pattern using the device language setting.

Monday, December 31, 2012 (en-US)

lunes, 31 de diciembre 2012 (es-ES)

Montag, 31. Dezember 2012 (de-DE)

MM/DD/YYYY Short date pattern, month first, slash delimited 12/31/2012
MM-DD-YYYY Short date pattern, month first, dash delimited 12-31-2012
DD/MM/YYYY Short date pattern, day first, slash delimited 31/12/2012
DD-MM-YYYY Short date pattern, day first, dash delimited 31-12-2012
YYYY/MM/DD Short date pattern, year first, slash delimited 2012/12/31
YYYY-MM-DD Short date pattern, year first, dash delimited 2012-12-31
MM.DD.YYYY Short date pattern, month first, dot delimited 12.31.2012
DD.MM.YYYY Short date pattern, day first, dot delimited 31.12.2012
YYYY.MM.DD Short date pattern, year first, dot delimited 2012.12.31
Note: There may be more or fewer patterns than those shown in this table.
Important: When you refer to a Date field in a script, the day (DD) and year (YYYY) designations must be in lower case. In other words, DD must be dd and YYYY must be yyyy. For example, when the format MM/DD/YYYY is required in scripting, the format should be specified by MM/dd/yyyy in the script. This applies to all of the date formats that use day (DD) or year (YYYY) designations.