Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Adding Date and Time together from a different field

Topic Labels: Dates & Timezones
354 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi All,

image

So I have a Date and Time field, in separate fields, I wanted to combine the 2 fields together in 1. Is there any formula for this case?

I’m looking for a result in this way “1/7/2022 19:00”

Thank you in advance!

My Best,
Mae

2 Replies 2

Try combining the two fields with CONCATENATE to create a string. You will likely need to use DateTime_Format as well in your concatenate field.

Then use DATETIME_PARSE

Hi @Mae_Infante,

Working with dates & times can be extremely tricky in Airtable!

I believe that this formula should work in your scenario:

DATETIME_PARSE(
DATETIME_FORMAT({Release Date},'M/D/YYYY') & {Dubai Release Time},
'M/D/YYYY H:mm'
)