Skip to main content
Question

Format Date , day / month reversal

  • February 27, 2020
  • 6 replies
  • 244 views

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



This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • February 28, 2020

Hi @Greg

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



  • Author
  • February 29, 2020

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








AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • February 29, 2020

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!



  • Author
  • February 29, 2020

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




AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • February 29, 2020

Time well spent learning the ins and outs of Zapier!



Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • March 2, 2020

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