Skip to main content
Solved

Can concatenate formula show just times, WITHOUT the date?

  • April 13, 2022
  • 2 replies
  • 45 views
Jessica_Pena
Forum|alt.badge.img+15

I’m trying to establish a schedule of events for a multi-day event and it would be optimal to have the primary field with a concatenate formula read:

CONCATENATE({Description (from Performer)}, " by ",{Performer}, " from ", {Start Time}, " to ", {End Time})

However, for Start and End times, I would love if ONLY the time (sans date) would show, because currently I have this mess showing:

Classical String Duet by XYZ Strings Band from 2022-04-14T02:00:00.000Z to 2022-04-14T03:30:00.000Z

TIA, Community!

Best answer by Vivid-Squid

Hi @Jessica_Pena ,
There is a TimeStr() option you can use in your formula. There are also other formats you can display the time as with DATETIME_FORMAT() : https://support.airtable.com/hc/en-us/articles/216141218

To add the DATETIME_FORMAT to your formula:
CONCATENATE({Description (from Performer)}, " by ",{Performer}, " from ", DATETIME_FORMAT({Start Time},‘LT’), " to ", DATETIME_FORMAT({End Time},‘LT’))

2 replies

V
Forum|alt.badge.img+16
  • Vivid-Squid
  • Inspiring
  • Answer
  • April 13, 2022

Hi @Jessica_Pena ,
There is a TimeStr() option you can use in your formula. There are also other formats you can display the time as with DATETIME_FORMAT() : https://support.airtable.com/hc/en-us/articles/216141218

To add the DATETIME_FORMAT to your formula:
CONCATENATE({Description (from Performer)}, " by ",{Performer}, " from ", DATETIME_FORMAT({Start Time},‘LT’), " to ", DATETIME_FORMAT({End Time},‘LT’))

E
Justin_Barrett
Jessica_Pena
Jessica_Pena
Forum|alt.badge.img+15
  • Jessica_Pena
  • Author
  • Known Participant
  • April 14, 2022

Hi @Jessica_Pena ,
There is a TimeStr() option you can use in your formula. There are also other formats you can display the time as with DATETIME_FORMAT() : https://support.airtable.com/hc/en-us/articles/216141218

To add the DATETIME_FORMAT to your formula:
CONCATENATE({Description (from Performer)}, " by ",{Performer}, " from ", DATETIME_FORMAT({Start Time},‘LT’), " to ", DATETIME_FORMAT({End Time},‘LT’))


Thank you very much!

Terms & ConditionsAccessibility statement