Dates
A description of the date format in use throughout the system
All dates in the system are stored in UTC, also known as Zulu time. This format is used as it's a universally recognised standard.
Date format in the API
When you call the API you will receive dates back from our system in the following format:
"2019-08-08T15:07:50.1968569Z"This contains the date as YYYY-MM-DD.
When calling the API, the preferred date format is to use YYYY-MM-DD, however we also support other formats, including YYYY/MM/DD and YYYYMMDD.
Date format in batch files
If you are uploading batch files (.csv and .xls), the regional settings of your machine can affect the date format used.
For example, if you're using Chrome and have your language settings set to English (United Kingdom), then the date 06/02/2021 will be interpreted as DD/MM/YYYY, i.e. 6th February 2021. If however your settings are English (United States), then the same date will be interpreted as MM/DD/YYYY, i.e. 2nd June 2021.
For this reason, we suggest that you always use one of the universal forms as follows:
- YYYY-MM-DD
- YYYY/MM/DD
- YYYYMMDD
Updated 17 days ago