Help

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

834 2
cancel
Showing results for 
Search instead for 
Did you mean: 
zerem
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:
 
 

 

zerem
6 - Interface Innovator
6 - Interface Innovator

thank you very much I'll check it!