I'm based in the UK and we've had an integration working on a booking database for over a year which automates the creation of an Outlook event when a booking is made. No changes have been made to this automation but today the events which are in Airtable as dd/mm have started coming through as mm/dd. I'm really at a loss with this and what I need to be looking into.
Wrong dates in Outlook automation
+2
+31Hmm, as a datapoint, I just tried creating an Outlook event via the automation for 28 Feb and it worked as expected, here's the date field set to display as European
And the created event is in +8 as that's my timezone, and this is the automation result:
And here's the date listed in the email invite:
I also tried changing the display of the field to be US to see if that changed anything and that worked fine:
If I were you I'd try creating a new automation to create an Outlook event with a new Date field and see if that works. If it does, then we rule out the Base being an issue. You could then update the new automation to use the original Date field to see if that works, etc and proceed to rule stuff out that way?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.