Emailed Spreadsheet from Automation Not Formatting Dates Properly

[mykrobinson]

I have an automation to send reports, and it is working for the most part, except any field with a Date is not showing correctly. My template for the first page of the sheet is as follows:

but what is being returned looks like this:

the data shows correctly in the app and in the spreadsheet the information is pulled from, I have no clue why these dates are not appearing correctly in the automation spreadsheet 🤔

[Marc_Dillon · Accepted solution]

Those are what "raw" datetime values look like. It is the number of days since a certain date, called an "epoch". You just need to format the column in the output file as date or datetime.