Date formats used during imports and exports

ClickUp reads and provides dates in various formats during imports and exports

Normal

  • Day, date, time, timezone offset

  • English formatting

  • Date fields without specific times are set to 4 a.m. in the local timezone of the person setting the field. 
    Example: May 30, 2019, PST would be Monday, May 30th, 2019, 4:00:00 a.m.–07:00

ISO (International Standard)

  • Year, month, day, (T) time

  • Date numbers separated by a hyphen ("-")

  • Time numbers separated by a colon (":")

  • Date numbers less than 10 are preceded by a zero
    Example: May 30, 2019 would be 2019-05-30T11:00:00.000Z

POSIX

  • The number of milliseconds that have elapsed since January 1, 1970. 

  • This format is the easiest for machines to read and perform calculations and comparisons with

  • Also known as Unix time, Unix epoch, or Unix timestamp.

  • Amazing converting tool: https://www.epochconverter.com/.
    Example: May 30, 2019 would be 1559178061000

Was this article helpful?