I have set my timezone in my profile correctly (UTC+2, “Europe/Amsterdam”).
I proceed to create a test zap for my application and enter a date into a datetime field, for example, “01-01-1992”. For some reason Zapier converts this date into the following datetime string:
This is UTC+1, not UTC+2, meaning this would actually an hour earlier and thus the date becomes: “31-12-1991”.
Has anyone else experienced this issue or am I missing something here?
Best answer by Liz_RobertsView original
@vitalyn! Timezones are tricky because there can be a few different factors at play. I’m going to escalate this to the Support Team so that they can take a closer look. I’ll be in touch via email to ask for a couple of extra details and you’ll be able to carry on the conversation with the team from there. Thanks!
Circling back with Support’s resolution from the initial post: it seems if you put in a plain date (without timestamp) into a Datetime field, the platform will convert that to a full timestamp in your time zone, before sending it to your integration via the bundle.inputData object.
Note that the conversion will use the time based on your time zone, and that particular date. If your integration only needs a date by itself, you'll want to parse that provided datetime field to remove the time component.
Please let us know if you have any additional questions- always happy to help!