Date
- Updated: 2021/11/05
Date
Specify any regular expression and special patterns in the Date data type.
The following table lists some common examples:
Field | Pattern | Notes |
---|---|---|
Date |
|
Supported date separators include /(forward slash), –(dash), space, .(dot), and ,(comma). Here,
|
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 |