Zapier Date issue

[JasonS (Jason Smith)]

I really didn’t think it would be that hard adding a date to a column from Zapier.

I have tried every possible value combination. But zapier keeps telling me the date format is wrong.

This is what I entered and this it should be. And the error I keep getting.

[mitchell.hudson]

Hi @JasonS,

I believe you need to format the date into a JSON value.

The value needs to be sent to the monday API V2 in this format: "{\"date\":\"2019-06-03\"}"

Zapier has a format function that you can use to parse this value.

[JasonS (Jason Smith)]

Hi @mitchell.hudson

I have tried your formating and still not working?

[dipro (Dipro Bhowmik)]

I believe Zapier takes care of turning your value into a JSON string. Can you try removing the additional quotes around the outside (and the backslashes)?

Basically, try this date value instead:

{“date” : “2019-06-03”}

[ddfla (designs)]

@dipro

{“date” : “2019-06-03”}

I’ve had the same issue as Jason. I’ve been at this for 2 hours now

[ddfla (designs)]

it’s formatted to the Same as monday.com (since I couldn’t get Monday’s format to change)

[Helen]

Hi @ddfla!

Sorry to hear that you’re dealing with this issue.

It looks like the date you’re inputting is in the date format of “March 31, 2021”. Instead, it should be “2021-03-31,” or YYYY-MM-DD as specified in this section of our API documentation: https://monday.com/developers/v2#column-values-section-date.

If this still doesn’t work for you, feel free to write into appsupport@monday.com!

-Helen