---
schema_version: "1"
id: 0a11a7f1377c8b2f20b1686f5abb7f42bb6caf4e86668cbb3270d46ce71e6acd
title: Valid Date Format in Records (2.0)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/api-asynch/guides/api-bulk-v2/datafiles/valid-date-format-in-records-2-0.md
canonical_url: https://developer.salesforce.com/docs/platform/api-asynch/guide/valid-date-format-in-records-2-0.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: abcc7cfa05589c4af39ad19d1d6c19864b9a310bdb00b2ab00e1b13445b14172
products:
  - Bulk API 2.0 and Bulk API Developer Guide
  - Platform Developer Content
---

# Valid Date Format in Records (2.0)

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](http://www.w3.org/TR/xmlschema-2/#dateTime).

## date

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

**note:** Specifying an offset for `date` is not supported.