Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Solved
Jump to Solution
1068 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_Bower
5 - Automation Enthusiast
5 - Automation Enthusiast

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
image

Has anyone run into this before or have a solution?

1 Solution

Accepted Solutions

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:

See Solution in Thread

3 Replies 3

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

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}
)

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: