Dear All,
I am trying to store the date and time into Airtable, where I have set the date format in the Airtable as per the below screen shot
Sharing the screenshot of the blocks:
I get the below error when I try to store details:
Could you kindly assist?
Regards,
Sasi Preetha
tatiang
November 16, 2022, 8:22am
2
I suspect the problem is that you’re missing the “T” between the date and time values. But I’m not that familiar with ISO format so I could be wrong.
Can you post an example of a valid date/time entry in Airtable? Not one generated from Thunkable, just one that you manually entered.
Edit: Here’s an example of a value that works for me:
2022-11-16T12:32
So you’ll need to add “T” to your join
block. And remove the “IST” string. The time zone is already formatted in Airtable and your blocks will fail if you include it.
2 Likes
martint
November 16, 2022, 8:58am
3
Try changing the column type to ‘Single line text’ in Airtable. The date is created in Thunkable so Airtable doesnt need to create the date & time.
Super It works after I joined T between date and time.
Thank you so much for y our assistance:)
Sharing the time format in the Airtable
2 Likes
I want it in Date and time format so Zapier works for me to send reminder. Thank you for your suggestion. Much appreciated.
1 Like