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

[zerem]

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!

[Greg_F]

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:

https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format

[zerem]

thank you very much I'll check it!