Adding Date and Time together from a different field

[Mae_Infante]

Hi All,

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

[Zack_S]

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

Convert Text to Date Dates and timezones

You’ll use the DATETIME_PARSE function for this. However, the PST vs PDT difference can’t be tracked, as the date format specifiers used by this function don’t provide that kind of control. Assuming your existing text-based dates are in a {Date} column, I originally wrote this formula: DATETIME_PARSE(Date, "YYYY-MM-DD hh:mm:ss") However, sometimes Airtable is smart enough to figure things out on its own: DATETIME_PARSE(Date) In either case, everything works fine: [26%20PM]

[ScottWorld]

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'
)