# \[Solved\] Unable to store the date and time format into Airtable-"Cannot parse datevalue"

**URL:** https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [November 16, 2022, 7:48am UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561 "2022-11-16T07:48:19Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [November 16, 2022, 7:48am UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561/1 "2022-11-16T07:48:19Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e30e012509806e942b5f1a5613c51cd95f056c8.png)

Sharing the screenshot of the blocks:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/f/afa2189028ef4123fcdfedde1003b5d9f62e049a.png)

I get the below error when I try to store details:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/9/59bb0b23de86c31bd73f58dd5e45ba6ecf37beb1.png)

Could you kindly assist?

Regards,  
Sasi Preetha

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [November 16, 2022, 8:22am UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561/2 "2022-11-16T08:22:03Z")

</div>

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`

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/6/463a03221ec8d1c290534b94203a56821a326a3a.png)

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/7523b4189f1ea6f94783586eb97b195e52a4546a.png)

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.

---

<div class="post-metadata">

### Author: ![martint](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/martint/32/96689_2.png) [@martint](https://community.thunkable.com/u/martint)
#### Post date: [November 16, 2022, 8:58am UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561/3 "2022-11-16T08:58:10Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [November 16, 2022, 9:03am UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561/4 "2022-11-16T09:03:25Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/9/e9b98c97be05226c25dd788978e5601bfb0915ba.png)

---

<div class="post-metadata">

### Author: ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [November 16, 2022, 9:04am UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561/5 "2022-11-16T09:04:45Z")

</div>

I want it in Date and time format so Zapier works for me to send reminder. Thank you for your suggestion. Much appreciated.

---

<div class="post-metadata">

### Author: ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)
#### Post date: [November 16, 2022, 3:18pm UTC](https://community.thunkable.com/t/solved-unable-to-store-the-date-and-time-format-into-airtable-cannot-parse-datevalue/2133561/6 "2022-11-16T15:18:11Z")

</div>