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.
  • 12/31/2019 (en-US)
  • 31/12/2019 (fr-FR)
  • 31/12/2019 (es-ES)
Device Long Date Long date pattern using the device language setting.
  • Monday, December 31, 2019 (en-US)
  • lunes, 31 de diciembre 2019 (es-ES)
  • Montag, 31. Dezember 2019 (de-DE)
MM/DD/YYYY Short date pattern, month first, slash delimited.
  • 12/31/2019
MM-DD-YYYY Short date pattern, month first, dash delimited.
  • 12-31-2019
DD/MM/YYYY Short date pattern, day first, slash delimited.
  • 31/12/2019
DD-MM-YYYY Short date pattern, day first, dash delimited.
  • 31-12-2019
YYYY/MM/DD Short date pattern, year first, slash delimited.
  • 2019/12/31
YYYY-MM-DD Short date pattern, year first, dash delimited.
  • 2019-12-31
MM.DD.YYYY Short date pattern, month first, dot delimited.
  • 12.31.2019
DD.MM.YYYY Short date pattern, day first, dot delimited.
  • 31.12.2019
YYYY.MM.DD Short date pattern, year first, dot delimited.
  • 2019.12.31

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.