Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

114 2
Showing results for 
Search instead for 
Did you mean: 

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:


thank you very much I'll check it!