Issue with mutation - change_column_value with date column

Hi there,

I’ve been using the Monday API to automatically post updates to a board for several weeks now. One of the columns that I’m changing is a Date column. Starting yesterday, all of my requests to change columns of this type have returned 400 errors, with the message:

{
  "error_code": "ColumnValueException",
  "status_code": 400,
  "error_message": "change_column_value invalid value",
  "error_data": {
    "column_value": "{\"date\"=>\"2019-11-1\", \"time\"=>\"12:39:00\"}",
    "column_type": "DateColumn"
  }
}

My query, obviously, does not have “=>” in it. My query looks like this:

mutation
    {
        change_column_value(
            board_id: 12335234,
            item_id: 2312342341231,
            column_id: date,
            value: "{\"date\":\"2019-11-1\", \"time\":\"12:39:00\"}"
        ) {
            id
            name
            column_values {
                id
                text
                value
            }
        }
    }

which, according to your documentation, is correct. Any input as to what could be happening/ what I’m doing wrong? Thanks!

Hey @chdastolfo, welcome to the community :slight_smile:

I tested this and I know the issue :slight_smile: Our date column expects dates in YYYY-MM-DD format, and your date is 2019-11-1 instead of 2019-11-01.

image

Let me know if that helps!