Syncari will convert hard-coded text to a date type as long as it is in one of the following formats.
NOTE: If comparing to a date/time field and time is omitted from the below formats then 00:00:00 UTC is assumed.
NOTE: If your hard-coded date can be interpreted as more than one date depending on the format the format list is the priority. So "2/1/19" will be evaluated as Februrary 1st 2019 not January 2nd 2019.
- E LLL d HH:mm:ss z y
- yyyy-MM-ddTHH:mm:ss.SSSz
- yyyy-MM-ddTHH:mm:ssz
- RFC_1123_DATE_TIME ('Tue, 3 Jun 2008 11:05:30 GMT')
- ISO_ZONED_DATE_TIME ('2011-12-03T10:15:30+01:00[Europe/Paris]')
- yyyy-MM-dd HH:mm:ss
- yyyy-M-d HH:mm:ss
- yyyy/MM/dd HH:mm:ss
- yyyy/M/d HH:mm:ss
- MM-dd-yyyy HH:mm:ss
- M-d-yyyy HH:mm:ss
- MM/dd/yyyy HH:mm:ss
- M/d/yyyy HH:mm:ss
- dd-MM-yyyy HH:mm:ss
- d-M-yyyy HH:mm:ss
- dd/MM/yyyy HH:mm:ss
- d/M/yyyy HH:mm:ss
- MM-dd-yy HH:mm:ss
- M-d-yy HH:mm:ss
- MM/dd/yy HH:mm:ss
- M/d/yy HH:mm:ss
- dd-MM-yy HH:mm:ss
- d-M-yy HH:mm:ss
- dd/MM/yy HH:mm:ss
- d/M/yy HH:mm:ss
- yyyy-MM-ddTHH:mm:ss.SSSZ
