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
There may be more or fewer patterns than those shown in this table.
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.