Date and Month getting mixed in Zapier integration

Developer Support APIs & Integrations
1

Hello,
I have a Zapier integration that updates a date field in HubSpot based on data entered in a Google Sheet.
The integration only works when the date is < 12. And that too by switching the month and date places.
Eg: HubSpot saves 07.09.2023 as 09/07/2023.

SDSouza29_0-1692888394008.png
SDSouza29_0-1692888394008.png282×307 23.8 KB

SDSouza29_1-1692888459025.png

SDSouza29_2-1692888478520.png

I do use a date formatter to change the format to MM.DD.YYY but this doesn’t fix it.
Has anyone manageed to find a solution here?
Thanks in advance,
Sid

2

Hi, @SDSouza29 :waving_hand: Did you figure out the root cause?

Best,

Jaycee

3

Hello @Jaycee_Lewis,
Unfortunately not yet. :pensive_face:
I now also tried formatting to YYYY-MM-DDTHH:mm:ssZ but was unsuccessful.
Should I try with UNIX?
Cheers,
Sid