Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Wrong dates in Outlook automation

256 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AbbyC
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, 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

Screenshot 2025-02-01 at 9.16.57 PM.png

And the created event is in +8 as that's my timezone, and this is the automation result:

Screenshot 2025-02-01 at 9.15.53 PM.png

And here's the date listed in the email invite:

Screenshot 2025-02-01 at 9.21.11 PM.png

I also tried changing the display of the field to be US to see if that changed anything and that worked fine:

Screenshot 2025-02-01 at 9.18.21 PM.png

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?