---
schema_version: "1"
id: 87c01d322548aaba41d521f8cf59b548f1cf89abb2c10d3152b49ed8e9249c0a
title: Date Formats
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/reference/bi-date-formats.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-date-formats.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: d887addff0bb529d5704ba0c50cccbf668f99bf80e59d5566f18bca10be7368d
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# Date Formats

For Date fields, specify the format of the date by using one of the following supported formats. Dates must match the format exactly and can't have any extra text.

**note:** The date formats listed here are the two-digit versions for date fields that use leading zeros; for example, **03/06/14 09:01:06 AM**. If a date field doesn't have leading zeros, use the one-digit version of the format. For example, use the format `M/d/yy h:m:s a` for date values such as **3/6/14 9:1:26 AM**. If you use a two-digit format for a field, rows containing values with one-digit date parts will fail.

The timestamp part of each date format is optional.

The Quarter date format isn’t supported.

| Format                       | Sample Value             |
| ---------------------------- | ------------------------ |
| yyyy-MM-dd'T'HH:mm:ss.SSS'Z' | 2014-04-29T16:53:34.000Z |
| yy-MM-dd'T'HH:mm:ss.SSS'Z'   | 14-04-29T16:53:34.000Z   |
| yyyy-MM-dd'T'HH:mm:ss'Z'     | 2014-04-29T16:53:34Z     |
| yy-MM-dd'T'HH:mm:ss'Z'       | 14-04-29T16:53:34Z       |
| yyyy-MM-dd HH:mm:ss          | 2014-06-03 11:31:45      |
| yy-MM-dd HH:mm:ss            | 14-06-03 11:31:45        |
| dd.MM.yyyy HH:mm:ss          | 03.06.2014 11:31:45      |
| dd.MM.yy HH:mm:ss            | 03.06.14 11:31:45        |
| dd/MM/yyyy HH:mm:ss          | 03/06/2014 11:31:45      |
| dd/MM/yy HH:mm:ss            | 03/06/14 11:31:45        |
| dd/MM/yyyy hh:mm:ss a        | 03/06/2014 11:31:45 AM   |
| dd/MM/yy hh:mm:ss a          | 03/06/14 11:31:45 AM     |
| dd-MM-yyyy HH:mm:ss          | 03-06-2014 11:31:45      |
| dd-MM-yy HH:mm:ss            | 03-06-14 11:31:45        |
| dd-MM-yyyy hh:mm:ss a        | 03-06-2014 11:31:45 AM   |
| dd-MM-yy hh:mm:ss a          | 03-06-14 11:31:45 AM     |
| MM/dd/yyyy hh:mm:ss a        | 06/03/2014 11:31:45 AM   |
| MM/dd/yy hh:mm:ss a          | 06/03/14 11:31:45 AM     |
| MM-dd-yyyy hh:mm:ss a        | 06-03-2014 11:31:45 AM   |
| MM-dd-yy hh:mm:ss a          | 06-03-14 11:31:45 AM     |
| HH:mm:ss dd/MM/yyyy          | 11:31:45 03/06/2014      |
| HH:mm:ss dd/MM/yy            | 11:31:45 03/06/14        |

These formats use the following symbols:

| Symbol     | Meaning                                             |
| ---------- | --------------------------------------------------- |
| yyyy or yy | Four-digit year (yyyy) or two-digit year (yy)       |
| MM         | Two-digit month (01–12)                             |
| M          | One-digit month when month less than 10 (1–12)      |
| dd         | Two-digit day (01–31)                               |
| d          | One-digit day when day less than 10 (1–31)          |
| 'T'        | A separator that indicates that time of day follows |
| HH         | Two-digit hour (00–23)                              |
| H          | One-digit hour when hour less than 10 (0–23)        |
| mm         | Two-digit minute (00–59)                            |
| m          | One-digit minute when minute less than 10 (0–59)    |
| ss         | Two-digit second (00–59)                            |
| s          | One-digit second when second less than 10 (0–59)    |
| SSS        | Optional three-digit milliseconds (000–999)         |
| 'Z'        | The reference UTC time zone                         |