Skip to main content
Solved

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

  • March 7, 2022
  • 3 replies
  • 46 views
K
Forum|alt.badge.img+4

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?

Best answer by Mohamed_Swella1

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:

3 replies

Mohamed_Swella1
Forum|alt.badge.img+17

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

K
K
Forum|alt.badge.img+4
  • Kevin_Bower
  • Author
  • New Participant
  • March 8, 2022

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

Mohamed_Swella1
Forum|alt.badge.img+17

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:

Terms & ConditionsAccessibility statement