Skip to main content
Best answer

Issue with Date/time formatter not swapping DD/MM values around

  • November 29, 2021
  • 4 replies
  • 57 views

Hello,

I have a date/time formatter steps that is not working as expected. For some reason, it is not swapping the DD/MM from input in the output.

Please check the screenshot, I have tried countless combinations but no luck. The output value should be 2021-12-07T13:11:00+1000

 

 

Output

 

Let me know if I missed anything.

 

Cheers

Thomas

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @Thomas2M 

Try using mm instead of MM for minutes:

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Thomas2M ,

 

Can you change the interviewdate column type to date and than try again?

 

 


  • Author
  • Beginner
  • 7 replies
  • November 29, 2021

Hi @jayeshkumarbhatia ,

 

I changed the column to date format, even changed the Google Sheet’s locale to Australia (since the dates are in Australian date format).

 

Still no luck :( 

 

 

For some reason formatter is incapable of adjusting DD/MM even though I explicitly specified the incoming format.

 

Let me know your thoughts.

Regards

 


jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Thomas2M ,

 

I will suggest you to reach out to Zapier team here https://zapier.com/help


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30829 replies
  • Answer
  • November 29, 2021

Hi @Thomas2M 

Try using mm instead of MM for minutes: