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/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

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.