Skip to content
Combining column da...
 
Notifications
Clear all

Combining column date and time into an Airtable date-time format

2 Posts
2 Users
0 Reactions
4 Views
jnuno
(@jnuno)
Posts: 1
New Member
Topic starter
 

What are you trying to achieve?

Hello,

I have a column named date with the format DD-MM-YYYY.
I have another column named time with the format HH24:MI.

How can I combine these into a single value suitable for insertion into Airtable? For example, 27-02-2025 19:35?

Thanks in advance.

Steps taken so far

I've experimented with various combinations using formatDate and parseDate, but I haven't yet found the correct formula.

Please provide the rewritten markdown content.

 
Posted : 26/02/2025 5:24 pm
samliew
(@samliew)
Posts: 293
Reputable Member
 

Welcome to the callin.io 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.

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

 
Posted : 27/02/2025 4:44 am
Share: