- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 11, 2018 03:00 PM
I’m noticing that I can’t use the Airtable API to create/edit columns of type Date. I’m using JS, and when I send in a date, I get the following error:
{"error":"INVALID_VALUE_FOR_COLUMN","message":"Field timestamp can not accept value 2018-09-11T17:42:38.000Z","statusCode":422}
However, it seems from your documentation that this is exactly how you’d like me to pass a Date
string (ISO 8601 formatted date)
UTC date, e.g. “2014-09-05”.
Any help/ acknowledgment of a bug would be greatly appreciated! Seems like a pretty core piece of functioality to not be working correctly

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 16, 2018 08:05 PM
I’m having this same issue… did you ever figure out a fix for it? It was working fine for me a week or so ago, so this seems to be a new bug
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 17, 2018 06:16 AM
Nope, it still is broken :frowning: Would appreciate an acknowledgement from the Airtable team about this pretty large bug

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 19, 2018 08:46 PM
I just had this issue, make sure your date column is also set to also accept time. Otherwise it will reject the date time string that you are passing.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 17, 2019 05:09 PM
I have the same problem with Barcode type field

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 18, 2019 07:40 AM
Let’s move your discussion to a more relevant thread (Fix for INVALID_VALUE_FOR_COLUMN for single line text column).

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 25, 2020 03:07 AM
same issue here. convert my date with toISOString() still not accepting it.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2021 07:33 PM
I solved it like this:
In airtable, set your column to Date format ISO with Time Field (12hours)
In node, ship a new Date().toISOString() and you’re gucci.
