Putting together column date + time into airtable date time

What are you trying to achieve?

Hello,

I have a column called date: DD-MM-YYYY
I have another column called time: HH24:MI

How can I make it a single value that can be inserted in Airtable? eg. 27-02-2025 19:35 ?

Thanks in advance

Steps taken so far

I have already tried different combinations with formatDate and parseDate but still not getting the right formula.

Welcome to the Make community!

You should be able to directly map both variables together since they are already in the required date and time format.

Screenshot_2025-02-27_120234 (2)

Hope this helps! Let me know if there are any further questions or issues.

ā€” @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.