Skip to main content

INVALID_VALUE_FOR_COLUMN with Dates

  • September 11, 2018
  • 7 replies
  • 148 views
H

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

7 replies

J
Forum|alt.badge.img+3
  • Jared_Ingold
  • Participating Frequently
  • 8 replies
  • September 17, 2018

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

H
  • Harris_Osserman
  • Author
  • New Participant
  • 1 reply
  • September 17, 2018

Nope, it still is broken :frowning: Would appreciate an acknowledgement from the Airtable team about this pretty large bug

A
Forum|alt.badge.img
  • Anthony_Howell
  • New Participant
  • 1 reply
  • December 20, 2018

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.

G
  • Gustavo_Costa
  • New Participant
  • 4 replies
  • November 18, 2019

I have the same problem with Barcode type field

E
  • EvanHahn
  • Participating Frequently
  • 37 replies
  • November 18, 2019

I have the same problem with Barcode type field


Let’s move your discussion to a more relevant thread (Fix for INVALID_VALUE_FOR_COLUMN for single line text column).

M
  • Malo_Richard1
  • New Participant
  • 2 replies
  • June 25, 2020

same issue here. convert my date with toISOString() still not accepting it.

N
  • Nathaniel_Kitzk
  • New Participant
  • 1 reply
  • September 25, 2021

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.


Terms & ConditionsAccessibility statement