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!
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')
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')
thank you very much I'll check it!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.