The date column represents a date, and can also include a time.

Check out our help center to learn more about this column: The Date Column

You can update a date column with a simple string value or a JSON string value.

Simple strings

To update a date column, send the date as a string in a YYYY-MM-DD format. You can also add a time by passing a “time” field in HH:MM:SS format. Ensure you separate the date and hour with a space.

You should enter the date and time in UTC, and it will be converted to the user's timezone when they look at the board.

Here's an example: "2019-06-03 13:25:00"

JSON

To update a date column with JSON, send a JSON string with a "date" key and an optional "time" key as well.

The "date" should be in YYYY-MM-DD format, and the time should be in HH:MM:SS format. Both should be in UTC, as the datetime will be converted to the user's timezone when they look at the board.

Code example

mutation {
  change_multiple_column_values(item_id:11111, board_id:22222, column_values: "{\"date\" : {\"date\" : \"1993-08-27\", \"time\" : \"18:00:00\"}}") {
    id
  }
}
fetch ("https://api.monday.com/v2", {
  method: 'post',
  headers: {
    'Content-Type': 'application/json',
    'Authorization' : 'YOUR_API_KEY'
  },
  body: JSON.stringify({
    query : "mutation ($myBoardId:Int!, $myItemId:Int!, $myColumnValues:JSON!) { change_multiple_column_values(item_id:$myItemId, board_id:$myBoardId, column_values: $myColumnValues) { id } }",
    variables : JSON.stringify({
      myBoardId: YOUR_BOARD_ID,
      myItemId: YOUR_ITEM_ID,
      myColumnValues: "{\"date5\" : {\"date\" : \"1993-08-27\", \"time\": \"18:00:00\"}}"
    })
  })
})
curl "https://api.monday.com/v2" \
-X POST \
-H "Content-Type:application/json" \
-H "Authorization:MY_API_KEY" \
-d '{"query":"mutation{change_multiple_column_values(item_id:162169283, board_id:162169280, column_values:\"{\\\"date5\\\" : {\\\"date\\\" : \\\"1993-08-27\\\"}}\"){name}}"}'

Did this page help you?