Skip to main content

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

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'


)

Reply


Terms & Conditions