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)
Hi @darragh , following up on this one if I may, the date format is correct in the table as below. Do you know how I would specify the timezone in the workflow email?
@garyGHL - you’ll have to use a formula to format it correctly for your workflow \
Didn’t know that was a thing. I tried this in the workflow email setting but it outputs the code rather than date. Did I misunderstand what you meant 
You have an appointment scheduled for TEXT(created at, “DD/MM/YYYY”)
created at is the field in question that shows 01/07/25 correctly in the table.
Sorry if I wasn’t clear @garyGHL . You’ll have to add a new Formula Field to your table, with the desired format, and then use that in your email.
No worries @darragh . Just so I understand for future purposes, the date field in the table displays correctly at the moment. So I need to create another formula field based on this field to format it to UK (which it already is)?
Current field = 01/07/2025
Formula field = 01/07/2025
Then use the formula field in the workflow email. Am I correct in thinking the real format under the current field is (mm/dd/yyyy) but for display purposes it outputs it the regional settings?
DateTime fields in Noloco are represented in local time and formatting, i.e. time time of your computer which is why they display ‘correctly’.
When the email is sent, it’s sent from the API, which doesn’t know what Timezone you are in, so it’s sent in UTC and default (US) formatting.
So if you have a text-formula of the date field, which will display as text, regardless of where you are in the world, it will always be correct for your use-case.
You can read more about our DateTime fields here: Dates & Time Zones | Noloco
We’re hoping to have better ways to do this in the future.
Great, go that now. I’ll apply to the smaller examples, we do have tables with lots of date fields so may leave those until a time it becomes imperative.
Thank you
