Date format for imports API

Developer Support APIs & Integrations
,
1

I cannot get dates to import into a custom Contacts field.

I’ve set `dateFormat` to `YEAR_MONTH_DAY` on the file. I’ve tried ISO8601, “YYYY/MM/DD hh:mm”, and “YYYY.MM.DD hh:mm”. All of these I’ve seen in posts saying they work, and none of them do. They all result in a `COULD_NOT_PARSE_DATE` error.

https://community.hubspot.com/t5/APIs-Integrations/date-format-in-impor-file/m-p/623771#M52699

The docs don’t give any information on what I should use. I’m quite frustrated with this.

2

Hi @GDennis

Call me “Old School” (because I am)… when I push dates tot he HubSpot API I always convert them to Microtime (Unix time in milliseconds).

Here’s a useful doc: HubSpot Developer Documentation - HubSpot docs

Have fun

Mike

Here to learn more about HubSpot and share my HubSpot Knowledge. I’m the founder of Webalite a Gold HubSpot Partner Agency based in Wellington, New Zealand and the founder of Portal-iQ the world’s first automated HubSpot Portal Audit that helps you work smarter with HubSpot.

3

I’ll give that a try. Thanks for the link.

4

That worked! Thank you.

5

Amazing information in comments.