Sales Integrations

t_stania
Member

Creating/Updating Contact from Gravity Forms using Zapier date incorrect

SOLVE

Hi,

 

I am using Zapier to gather information from a submitted Gravity Form and push the information into a new or existing contact. 

 

The problem is, within Zapier, the step that involves taking the date as YYYY-MM-DD does an incorrect converstion to Unix Time.

 

Data Out is shown as 1510444800000. But data in is 2017-11-13. 1510444800000 when converted back to Unix time is 2017-11-12 which is incorrect. This value is then pushed into Hubspot. So, the date is always -1 day......And I have no Idea why. Has it got to do with my timezones? I'm in Australia

 

data outdata outdata indata in

0 Upvotes
1 Accepted solution
t_stania
Solution
Member

Creating/Updating Contact from Gravity Forms using Zapier date incorrect

SOLVE

Ok, so I've answered my own question- (I hate it when that happens ;). Zapier timezone was set to Australia (GMT +10). I changed back to UTC and now it works.

View solution in original post

0 Upvotes
2 Replies 2
t_stania
Solution
Member

Creating/Updating Contact from Gravity Forms using Zapier date incorrect

SOLVE

Ok, so I've answered my own question- (I hate it when that happens ;). Zapier timezone was set to Australia (GMT +10). I changed back to UTC and now it works.

0 Upvotes
jennysowyrda
Community Manager
Community Manager

Creating/Updating Contact from Gravity Forms using Zapier date incorrect

SOLVE

Hey @t_stania

 

I am glad you were able to figure out what was going on, and thank you for sharing the answer with the community! 🙂 

 

Jenny

0 Upvotes