Format Dates for Email Action

Topic Labels: Automations
Jump to Solution
10406 11
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

When inserting a Date field in an Email Action, the Date and Time format I’ve set within the table does not get used. Instead, I get the default formatting, something like: 2020-06-07T01:00:00.000Z. I’d like the date and time to be outputted in a more readable format in emails, something like 6/7/2020 at 1:00am.

11 Replies 11

OMGosh, so simple but it worked. Thanks for coming back and updating with the fix.

5 - Automation Enthusiast
5 - Automation Enthusiast

While this fix is indeed easy, can someone explain why do we need to do it this way?
I would expect that FORMATTING a field in data model will apply the same format everywhere, so would like to work it that way, without adding formulas to format it