Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 07, 2022 01:47 PM
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?
Solved! Go to Solution.
Mar 08, 2022 10:15 AM
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:
Mar 07, 2022 09:34 PM
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
Mar 08, 2022 06:58 AM
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}
)
Mar 08, 2022 10:15 AM
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: