Supported Date Formats for Comparison

Brandon Lee
Brandon Lee
  • Updated

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


Share this

Was this article helpful?

2 out of 2 found this helpful