Data type formats

Valid Date and DateTime Formats

Specify the right format for dateTime and date fields.

DateTime

Use the yyyy-MM-ddTHH:mm:ss or yyyy-MM-ddTHH:mm:ssZ 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)
• '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, 2021-10-10T12:00:00+05:00
is 2021-10-10T07:00:00Z and 2012-10-10T00:00:00+05:00 is 2012-10-09T19:00:00Z.

Date

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