Date

Specify any regular expression and special patterns in the Date data type.

The following table lists some common examples:

Field Pattern Notes
Date
  • d-m-yy
  • dd-mm-yy
  • mm-dd-yy
  • dd-mm-yyyy
  • mm-dd-yyyy
  • dd-mmm-yyyy
  • mmmm dd, yyyy

Supported date separators include /(forward slash), –(dash), space, .(dot), and ,(comma).

Here,

  • d - Numeric day of the month, from 1 through 31 (eg. 5, 15 etc.)
  • dd - Numeric day of the month, from 01 through 31 (eg. 05, 15 etc.)
  • m - Numeric month (eg. 1 for January)
  • mm - Numeric month (eg. 01 for January)
  • mmm - First 3 letters of the month (eg. NOV for November)
  • mmmm - Full name of the month (eg. June)

The following table lists some date examples and it's corresponding valid patterns:

Date Pattern
01-31-18 mm-dd-yy
Jan-31-2018 mmm-dd-yyyy
January 31, 2018 mmmm dd, yyyy
January 9, 2018 Mmmm d, yyyy
9 5 15 D M YY
9 11 15 D MM YY
7 MAR 15 D MMM YY
7 MARCH 15 D MMMM YY
5 05 2018 M DD YYYY
5/05/18 D/MM/YY
9/5/15 M/D/YY
05 / 9 / 2018 DD / M / YYYY
MAR / 05 / 18 MMM / DD / YY
09-APRIL-18 D-MMMM-YY
5-5-18 M-D-YY
11-5-18 MM-D-YY
NOV-13-2018 MMM-DD-YYYY
13 - 5 – 2019 DD - M - YYYY
OCTOBER - 05 – 18 MMMM - DD - YY
05.APRIL.2018 D.MMMM.YYYY
APRIL.05.2018 MMMM.DD.YYYY
5 . 5 . 18 D . M . YY
5 . 05 . 18 D . MM . YY
05 . JUL . 18 DD . MMM . YY
5 . 11 . 2018 M . DD . YYYY
MAY . 13 . 13 MMMM . DD . YY
2018-01-27 YYYY-MM-DD
2017/07/27 YYYY/MM/DD