Valid Date Format in Records

Specify the right format for dateTime and date fields.

dateTime

Use the yyyy-MM-ddTHH:mm:ss.SSS+/-HH:mm or yyyy-MM-ddTHH:mm:ss.SSSZ formats to specify dateTime fields.

yyyy is the four-digit year
MM is the two-digit month (01-12)
dd is the two-digit day (01-31)
‘T’ is a separator indicating that time-of-day follows
HH is the two-digit hour (00-23)
mm is the two-digit minute (00-59)
ss is the two-digit seconds (00-59)
SSS is the optional three-digit milliseconds (000-999)
+/-HH:mm is the Zulu (UTC) time zone offset
‘Z’ is the reference UTC timezone

When a timezone is added to a UTC dateTime, the result is the date and time in that timezone. For example, 2002-10-10T12:00:00+05:00 is 2002-10-10T07:00:00Z and 2002-10-10T00:00:00+05:00 is 2002-10-09T19:00:00Z. See W3C XML Schema Part 2: DateTime Datatype.

date

Use the yyyy-MM-dd format to specify date fields.

Specifying an offset for date is not supported.

Note