Skip to main content

Hello everyone,

after several attempts, I can't format the incoming dates in zapier.

Mail Parser sends me the data DD MM YYYY

I want to recover them exactly like that in Airtable.

The prolem is that zapier turns me into MM DD YYYY

Suddenly impossible to read them correctly by Airtable.

I tried everything with the formatter zapier nothing helps ...

thank you very much



Hi @Greg

Can you show us a screengrab of how you have the formatter step setup please.



Hello @AndrewJDavison_Luhhu

here are the screenshots, I don't understand I have two dates for input

and one for output ...

Capture d’écran 2020-02-29 à 09.28.01.pngCapture d’écran 2020-02-29 à 09.19.04.pngCapture d’écran 2020-02-29 à 09.16.09.pngCapture d’écran 2020-02-29 à 09.14.05.pngI request to have a format DD MM YYYY and I end up with a format YYYY DD MM

Thank you for your help








Hi @Greg

Can you show us the output step of the formatter and/or where it's giving you back the date in the wrong format? I can't see it form your screengrabs.

Thanks!



Capture d’écran 2020-02-29 à 11.38.27.png



my apologies for the inconvenience, beginner's mistake ...

I just hadn't reformatted the recording. I spent 2 hours on it :(

We learn little by little

Thanks @AndrewJDavison_Luhhu




Time well spent learning the ins and outs of Zapier!



Hi @Greg!

Just so that we can be super sure what we're seeing, could you please take a screenshot of the set up of your Formatter step (or steps if you have more than one)?

Something a bit like this:

Untitled Image