Skip to main content

Hi - couldn’t find an answer already for this, but sorry if it’s there and I didn’t see it. Not even sure if this is a Salesforce or  Zapier issue…

I convert a date to dd/MM/yyyy in Zapier with formatter, but when it arrives in Salesforce, it has been switched to MM/dd/yyyy. Eg, if I send:

transform: date.formatting

to_timezone: Europe/London

from_timezone: UTC

inputs: 1686528000

to_format: DD/MM/YYYY

 

output: 12/06/2023

 

I get a date in Salesforce of 6 December 2023

 

What am I doing wrong??

Thanks in advance!

Welcome to the Community, @Corinne!

Ah, yes it looks like the day and month are being swapped around as Salesforce is interpreting that date incorrectly. It looks like the format you’ll want to change it to is YYYY-MM-DDThh🇲🇲ss+hh:mm 

To do that you’ll need to use the custom value option and enter that date format into the To Format field. For example:

296953421f5264d5350d957cd90ed7d8.png

Can you try changing that format and let us know if that does the trick?


Perfect! Thank you!


You’re most welcome @Corinne. Glad I could help! 😁🎉

Please do get in touch if you run into any further issues at all, always happy to help! 


Reply