Date Parser
| The date parser knows over 40 date-string formats in autodetection mode: | |
|---|---|
| Parse pattern | Detection condition |
| (yesterday|today|tomorrow) | |
| wdn | |
| wdn[,] mmm d[ (yy|yyyy)] | |
| wdn[,] d[.][ ]mmm[,][ ][(yy|yyyy)] | |
| wdn[,] d[.][ ]m[.][ ][(yy|yyyy)] | |
| mmm d[ yyyy] | |
| mmm/d[/(yy|yyyy)] | |
| mmm-d[-(yy|yyyy)] | |
| yyyy[-]Www[-]n | |
| yyyy(-|/)m(-|/)d | |
| yyyy(-|/)n[n[n]] | |
| yy[-]Www[-]n | |
| yy-nnn | |
| d. mmm [(yy|yyyy)] | |
| d.m.[(yy|yyyy)] | |
| d-mmm[-(yy|yyyy)] | |
| d-m[-yyyy] | |
| yyyymmdd | ddmmyyyy | valid date test |
| jjjjjjj | yyyynnn | (1723980 <= JD <= 2914672) |
| JJJJJ | |
| JJJJJJ | yymmdd | (MJD <= 514671) |
| d-m-yy | yy-m-d | (yy > 31 | valid date test) |
| d/m[/yyyy] | m/d/yyyy | valid date test |
| d/m/yy | m/d/yy | yy/m/d | valid date test |
| Symbol | Explanation |
| () | grouping |
| | | alternative |
| [] | option |
| d | day-number (1-2 digits) |
| dd | 2 digit day |
| n | 1 digit day within week (1-7 = Mon-Sun) |
| nnn | 3 digit day within year |
| ww | 2 digit week within year |
| m | month-number (1-2 digits) |
| mm | 2 digit month |
| yy | 2 digit year |
| yyyy | 4 digit year |
| JJJJJ | 5 digit MJD |
| JJJJJJ | 6 digit MJD |
| jjjjjjj | 7 digit JD |
| wdn | weekday name (long|short in any supported language!) |
| mmm | month-name (long|short in any supported language!) to the short version you can add a '.' |