Date

Select the desired Date Format.

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

Note: There may be more or fewer patterns than those shown in this table.