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.