Date format changed when table view is added to Send email automation

[AndyLecap]

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. 

[TheTimeSavingCo]

Might be a timezone issue.  Could you try setting your "DOB" field to "GMT/UTC" and see what the value is?

[Pascal_Gallais- · Accepted solution]

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 

DATETIME_FORMAT({Date},'DD/MM/YYYY')), and then use this field in my automation when printing to a document or a mail.

Regards

Pascal

[AndyLecap]

Can't see GMT/UTC option for our date fields. I tried the European one and that had no effect.

[AndyLecap]

Thank you Pascal.

[TheTimeSavingCo]

Ah, I completely misunderstood your problem, sorry about that!  Glad you got it sorted!