To note - the system assumes UTC (GMT), so if importing a date/time that was during BST, you'll need to account for that
When using dates or date/times for any field included in a CSV file uploaded either through AWS or the Importer, please provide them in one of the following formats:
- yyyy-mm-dd
- Example: 2016-11-01
- yyyy-mm-ddThh:mm:ss
- Remember that this assumes UTC time
- Example: 2016-11-01T12:00:00
- yyyy-mm-ddThh:mm:ss offset (where timezone offset is either + or -, and hh:mm)
- Example: 2016-11-01T12:00:00-04:00
Notes
- For most imports, you will only need to use the date format
- For imports such as appointments, you may use the date-only format
We formatted dates with the time for appointments (or notes)! Why is it not working?
The date/time formatting must be formatted precisely in order for it to successfully upload. If only the date is formatted correctly, it won't process any data after that.
- 2016-11-01T12:00:00-04:00 - Works
- 2016-11-01 12:00 -400 - Will not work
-------------------------------------------------------------------
**Please Note: Dates can now be included with the following formatting (as of 6/11/2018):
MM/DD/YYYY
However, if you do include dates with this formatting, the following option must be selected when uploading your file: