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.
+12To 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.
- Ensure the date-time format in Make matches Airtable’s required format
- Utilize Make's formatter tool to adjust the date and time format before sending the data to Airtable.
- Verify that the Airtable field is set to date and time, not just date.
+35How 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
+3How 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
This is the configuration I am using for sending it, and as you can check the output is always to 00:00
+3To 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.
- Ensure the date-time format in Make matches Airtable’s required format
- Utilize Make's formatter tool to adjust the date and time format before sending the data to Airtable.
- Verify that the Airtable field is set to date and time, not just date.
Hi,
I don´t see any strange thing here
+35You may want to ask Make support about it, and post back here with what they say.
+3To 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.
- Ensure the date-time format in Make matches Airtable’s required format
- Utilize Make's formatter tool to adjust the date and time format before sending the data to Airtable.
- Verify that the Airtable field is set to date and time, not just date.
I have already done but no answer for them yet.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.