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