Hello, we are UK based so date formats are 28/06/2024, the front end app itself does display this correctly but the database table displays 06/28/2024, this then causes the workflows to also display 06/28/2024 when using any dates in push notifications, emails & comments.
Not a massive issue but is there setting I’ve missed to resolve this at all?
There’s not no, if you want to use dates in a workflow/automation you should use a formula field to format the date the way you want it
In your app, we can tell where you’re located, that’s not possible from workflows.
In the future we might introduce an ‘App locale’ setting, but it’s not something we support right now
Just revisited this as its now throwing random dates too.
I just created this record front end:
This is the email we received via workflow:
Date format is different from the table and hour is -1. If the user doesnt select a time it defaults to this:
Hey @garyGHL , workflows will format your dates in US format (mm/dd/yyyy) and in UTC.
UK, where you’re based is currently GMT+1 which is one hour ahead of UTC, which is why you’re seeing the times “wrong”
If you want to use them exactly as that in your workflows, you’ll need to either specify the timezone in your email, or use a formula to convert it to your timezone (or the one you need)
