Jul 09, 2024 02:15 AM
I use the found records automation to create my report and the date is in the correct format, her DoB is 10th July
But when I add this as a grid of records to the Send an Email automation, the DoB shows as 7/10/1953 i.e. 7th October.
and this is what arrives in the recipient's email.
Solved! Go to Solution.
Jul 09, 2024 06:32 AM
Hello Andy,
In case changing field settings does not work.
I have faced the same problem with automations when printing a date in a document or a mail. I solved this issue by adding a formula field in my table to format the date as I want it to be printed, for example
Jul 09, 2024 02:47 AM
Might be a timezone issue. Could you try setting your "DOB" field to "GMT/UTC" and see what the value is?
Jul 09, 2024 06:32 AM
Hello Andy,
In case changing field settings does not work.
I have faced the same problem with automations when printing a date in a document or a mail. I solved this issue by adding a formula field in my table to format the date as I want it to be printed, for example
Jul 12, 2024 02:36 AM
Can't see GMT/UTC option for our date fields. I tried the European one and that had no effect.
Jul 12, 2024 02:40 AM
Thank you Pascal.
Jul 13, 2024 02:06 AM
Ah, I completely misunderstood your problem, sorry about that! Glad you got it sorted!