Skip to main content

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.

 

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. 

  •  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.

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

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


 

This is the configuration I am using for sending it, and as you can check the output is always to 00:00

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. 

  •  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

 

You may want to ask Make support about it, and post back here with what they say. 

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. 

  •  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.

Reply


Terms & Conditions