Date formats
Refer to this table for the date formats. There may be more or fewer patterns than those shown in the table.
To select a date range, select the Restrict to date range check box and enter the start and end for the range in the From and To boxes.
Date type | Description | Examples |
---|---|---|
Device Short Date | Short date pattern using the device language setting. |
|
Device Long Date | Long date pattern using the device language setting. |
|
MM/DD/YYYY | Short date pattern, month first, slash delimited. |
|
MM-DD-YYYY | Short date pattern, month first, dash delimited. |
|
DD/MM/YYYY | Short date pattern, day first, slash delimited. |
|
DD-MM-YYYY | Short date pattern, day first, dash delimited. |
|
YYYY/MM/DD | Short date pattern, year first, slash delimited. |
|
YYYY-MM-DD | Short date pattern, year first, dash delimited. |
|
MM.DD.YYYY | Short date pattern, month first, dot delimited. |
|
DD.MM.YYYY | Short date pattern, day first, dot delimited. |
|
YYYY.MM.DD | Short date pattern, year first, dot delimited. |
|
When using the Date field in scripting, day (DD) and year (YYYY) designations must be in lower case. "DD" should be "dd" and "YYYY" should be "yyyy". For example, when the format MM/DD/YYYY is required in scripting, the format should actually be MM/dd/yyyy. This applies to all of the date formats that use day (DD) or year (YYYY) designations.