Aug 02, 2024 12:44 AM
I am working with make + airtable but when i try to write the date + time in my airtable with the data from make the date applies correctly but not the hour. It always insert 00:00 time. What is wrong here? thanks in advance.
Aug 02, 2024 01:22 AM
To ensure that both the date and time are correctly written to Airtable from Make, it's essential to format the date and time data properly before sending it.
Aug 02, 2024 01:22 AM - edited Aug 02, 2024 01:23 AM
How are you sending the date to Airtable in that “Create Record” module?
You will likely need to use Make’s “formatDate” function to make sure you’re sending both a date & time string to Airtable.
(Your specific problem might happen if your field was originally a date-only field with time turned off in Airtable. Make typically remembers the original settings for the field unless you refresh the module in Make. However, using formatDate should solve the problem under all circumstances.)
Hope this helps!
— ScottWorld, Expert Airtable Consultant
Aug 02, 2024 01:26 AM
This is the configuration I am using for sending it, and as you can check the output is always to 00:00
Aug 02, 2024 01:29 AM
Hi,
I don´t see any strange thing here
Aug 02, 2024 05:22 AM
You may want to ask Make support about it, and post back here with what they say.
Aug 04, 2024 10:02 PM
I have already done but no answer for them yet.