Help

Date Time not correct when integrate with make

Topic Labels: Automations
844 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Oscar_Ramiro
4 - Data Explorer
4 - Data Explorer

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.

Oscar_Ramiro_0-1722584580342.png

Oscar_Ramiro_1-1722584602203.png

 

6 Replies 6
Sachin_191
7 - App Architect
7 - App Architect

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.
ScottWorld
18 - Pluto
18 - Pluto

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

Oscar_Ramiro_0-1722587124312.png

Oscar_Ramiro_1-1722587175345.png

 

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

Hi,

Oscar_Ramiro_2-1722587254440.pngOscar_Ramiro_3-1722587304100.pngOscar_Ramiro_4-1722587357718.png

Oscar_Ramiro_5-1722587377055.png

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. 

I have already done but no answer for them yet.