How can I separate the "date" into "date and "time" in separate columns?

1012 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hey friends
I have a connection to Airtable that transfers every new lead to my table.
I have a date column and an hour column, but I don't know how to separate it, so every time a new lead is updated, it is only updated with the date and the hour remains empty.

How can I separate them so that both columns are updated with the relevant details?

Thank you!

2 Replies 2

Hi @zerem ,

You can add formula in that column, which will take your date and format it to show only time:



DATETIME_FORMAT(Date,'hh:mm a')


You can see this page for full options on the date formatting:


6 - Interface Innovator
6 - Interface Innovator

thank you very much I'll check it!