How to separate multiple dates pulling from look up fields and have them readable

[Kevin_Bower]

I have used this formula to separate data that is simple 4 letter abbreviations and it works perfectly. However, the data is also associated with dates and times that I need to separate and have readable and separate in an email automation. When I use the above method, the dates (which read fine in their native field) come out looking like this

Has anyone run into this before or have a solution?

[Mohamed_Swella1]

Hi @Kevin_Bower ,

Welcome to Airtable Community !

This is the ISO date formate, you can use the DATETIME_FORMAT() in the formula to make it more friendly

[Kevin_Bower]

Thank you for your response! So Ive used DATETIME_FORMAT In the fields that are being fed and it comes out wrong still. Are you saying somewhere in the larger formula you could drop it in? If so where would it go in this sequence?

IF( FIND("," , {Time}),
LEFT({Time},
FIND(",", {Time})-1
),
{Time}
)

[Mohamed_Swella1 · Accepted solution]

I think this might solve the issue

IF( FIND("," , {Time}),
DATETIME_FORMAT(LEFT({Time},
FIND(",", {Time})-1
),‘MM/DD/YYYY hh:mm a’),
DATETIME_FORMAT({Time},‘MM/DD/YYYY hh:mm a’)
)

Take care of the timezone though if you are using Time in your email. If you dont need the time, you can get ride of the “hh:mm a”

Let me know if this works :slightly_smiling_face: