Help

Separate Date/Time field into two fields?

Topic Labels: Formulas
2301 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Davol
5 - Automation Enthusiast
5 - Automation Enthusiast

I am exporting events from Airtable base into a web calendar via CSV. The web calendar requires that date and time be imported as separate fields.

To create a “date-only” field in Airtable, I simply duplicated the Airtable Date/Time field and turned off time. Done.

Now I need a way to create a separate “time-only” field in Airtable. Can someone recommend a formula that extracts the time from an Airtable Date/Time field? Converting it to text would be fine. For example, converting “4/14/2019 1:00pm” to “1:00pm”.

Thanks for your help

1 Reply 1
Mike_McLaughlin
8 - Airtable Astronomer
8 - Airtable Astronomer

look here, there are specifiers you can use to just get the date or just the time or any combination thereof in any format you can think of from a date time field.

If you are importing data, you may need to use a datetime_parse() first to interpret the date from a text value.