The date column represents a specific date (and potentially time). The API allows you to read, filter, update, and clear the date column.

Read a date column

You can query the date column using the column_values object that enables you to return column-specific subfields by sending a fragment in your query. Values for the date column are of the DateValue type.

query {
  items(ids: [1234567890, 9876543210]) {
    column_values {
      ... on DateValue {
        date
        time
      }
    }
  }
}

import { ApiClient } from "@mondaydotcomorg/api";
const mondayApiClient = new ApiClient({ token: myToken });

const query = `query($itemIds: [ID!]) { items (ids:$itemIds) { column_values { value ... on DateValue { date time } } } }`;
const variables = {
  itemIds: [9571351485, 9572374902],
};

const response = await mondayApiClient.request(query, variables);

Fields

Field	Description
column `Column!`	The column the value belongs to.
date `String`	The column's date value.
icon `String`	The selected icon as a string.
id `ID!`	The column's unique identifier.
text `String`	The column's value as text. This field will return `""` if the column has an empty value.
time `String`	The column's time value. Results are based on the timezone settings configured in the monday.com profile of the user who made the call.
type `ColumnType!`	The column's type.
updated_at `Date`	The column's last updated date.
value `JSON`	The column's JSON-formatted raw value. Results are in UTC.

Filter a date column

Using the items_page object, you can easily filter a board's items by specific columns or column values.

This section explains how to use the API to filter by dates. To query items with a specific date column value, you must add an operator with one or more predefined or custom compare values. Some compare values are static (e.g., specific dates), while others are dynamic and will change according to the date and time during which you make the API call (e.g., "TOMORROW").

💡 The results depend on the timezone, date format, and first day of the week settings configured in the monday.com profile of the user making the API call.

The table below outlines the supported operators, compare values, and compare attributes for the date column.

Compare value	Description	Operators
`"TODAY"`	Items with today's date.	`any_of`: returns items with today's date `not_any_of`: returns items with a date that is not today `greater_than`: returns items with any date after today's `greater_than_or_equals`: returns items with today's date or later `lower_than`: returns items with any date before today's `lower_than_or_equal`: returns items with today's date or earlier
`"TOMORROW"`	Items with tomorrow's date.	`any_of`: returns items with tomorrow's date `not_any_of`: returns items with a date that is not tomorrow `greater_than`: returns items with any date after tomorrow's `greater_than_or_equals`: returns items with tomorrow's date or later `lower_than`: returns items with any date before tomorrow's `lower_than_or_equal`: returns items with tomorrow's date or earlier
`"YESTERDAY"`	Items with yesterday's date.	`any_of`: returns items with yesterday's date `not_any_of`: returns items with a date that is not yesterday `greater_than`: returns items with any date after yesterday's `greater_than_or_equals`: returns items with yesterday's date or later `lower_than`: returns items with any date before yesterday's `lower_than_or_equal`: returns items with yesterday's date or earlier
`"THIS_WEEK"`	Items with a date during the current week. The first day of the week (either Sunday or Monday) is defined based on the settings configured in the monday.com account of the person making the API call.	`any_of`: returns items with a date during the current week `not_any_of`: returns items with a date that is not in the current week `greater_than`: returns items with any date after this week `greater_than_or_equals`: returns items with any date during or after the current week `lower_than`: returns items with any date before this week `lower_than_or_equal`: returns items with any date during or before the current week
`"ONE_WEEK_AGO"`	Items with a date during the previous week. The first day of the week (either Sunday or Monday) is defined based on the settings configured in the monday.com account of the person making the API call.	`any_of`: returns items with a date in the previous week `not_any_of`: returns items with a date that is not in the previous week `greater_than`: returns items with any date after the previous week `greater_than_or_equals`: returns items with any date during or after the previous week `lower_than`: returns items with any date before the previous week `lower_than_or_equal`: returns items with any date during or before the previous week
`"ONE_WEEK_FROM_NOW"`	Items with a date during the upcoming week. The first day of the week (either Sunday or Monday) is defined based on the settings configured in the monday.com account of the person making the API call.	`any_of`: returns items with a date in the upcoming week `not_any_of`: returns items with a date that is not in the upcoming week `greater_than`: returns items with any date after the upcoming week `greater_than_or_equals`: returns items with any date during or after the upcoming week `lower_than`: returns items with any date before the upcoming week `lower_than_or_equal`: returns items with any date during or before the upcoming week
`"THIS_MONTH"`	Items with a date during the current month.	`any_of`: returns items with a date in the current month `not_any_of`: returns items with a date that is not in the current month `greater_than`: returns items with any date after the current month `greater_than_or_equals`: returns items with any date during or after the current month `lower_than`: returns items with any date before the current month `lower_than_or_equal`: returns items with any date during or before the current month
`"ONE_MONTH_AGO"`	Items with a date during the previous month.	`any_of`: returns items with a date in the previous month `not_any_of`: returns items with a date that is not in the previous month `greater_than`: returns items with any date after the previous month `greater_than_or_equals`: returns items with any date during or after the previous month `lower_than`: returns items with any date before the previous month `lower_than_or_equal`: returns items with any date during or before the previous month
`"ONE_MONTH_FROM_NOW"`	Items with a date during the upcoming month.	`any_of`: returns items with a date in the upcoming month `not_any_of`: returns items with a date that is not in the upcoming month `greater_than`: returns items with any date after the upcoming month `greater_than_or_equals`: returns items with any date during or after the upcoming month `lower_than`: returns items with any date before the upcoming month `lower_than_or_equal`: returns items with any date during or before the upcoming month
`"PAST_DATETIME"`	Items with a date and time in the past.	`any_of`: returns items with a date and time in the past `not_any_of`: returns items with a date and time that is not in the past
`"FUTURE_DATETIME"`	Items with a date and time in the future.	`any_of`: returns items with a date and time in the future `not_any_of`: returns items with a date and time that is not in the future
`"UPCOMING"`	Used in conjunction with a status column, this compare value returns items that are not marked as "Done" and the date in the date column has not passed. Please note that the item will not show as upcoming if today's date is in the date column.	`any_of`: returns items not marked as "Done" before the date in the date column `not_any_of`: returns items marked as "Done" before the date in the date column
`"OVERDUE"`	Used in conjunction with a status column, this compare value returns items that are not marked as "Done" and the date in the date column has passed. Please note that the item will not show as overdue until the following day if the date column contains today's date.	`any_of`: returns items not marked as "Done" after the date in the date column `not_any_of`: returns items marked as "Done" after the date in the date column
`"DONE_ON_TIME"`	Used in conjunction with a status column, this compare value returns items that were marked as "Done" before the date in the date column.	`any_of`: returns items that were completed before the date `not_any_of`: returns items that were not completed before the date
`"DONE_OVERDUE"`	Used in conjunction with a status column, this compare value returns items that were marked as "Done" after the date in the date column.	`any_of`: returns items that were completed after the date `not_any_of`: returns items that were not completed after the date
Exact dates (e.g., `"2023-07-01"`	You can return items with an exact/static date by sending the date as a string with the `"EXACT"` compare value. The dates must be in "YYYY-MM-DD" format. For example: `["EXACT", "2023-07-01"]`	`any_of`: returns items with a specific date. Must be used in conjunction with the `"EXACT"` compare value. `not_any_of`: returns items with any date besides the specified one. Must be used in conjunction with the `"EXACT"` compare value. `between`: returns items between two specific dates `greater_than`: returns items with any date after the specified date. Must be used in conjunction with the `"EXACT"` compare value. `greater_than_or_equals`: returns items with any date during or after the upcoming week. Must be used in conjunction with the `"EXACT"` compare value. `lower_than`: returns items with any date before the upcoming week. Must be used in conjunction with the `"EXACT"` compare value. `lower_than_or_equal`: returns items with any date during or before the upcoming week. Must be used in conjunction with the `"EXACT"` compare value.
`"EXACT"`	Used with select operators to return items with a specific date.
`"$$$blank$$$"`	Items with a blank value.	`any_of`: returns items with a blank value `not_any_of`: returns items without a blank value

Examples

This example returns all items on board 1234567890 with a date column value of July 1st, 2023 (based on the user making the API call). To return items with a specific date, just replace the"2023-07-01" with the date you'd like to filter by!

query {
  boards(ids: [1234567890]) {
    items_page(
      query_params: {
        rules: [
          {
            column_id: "date"
            compare_value: ["EXACT", "2023-07-01"]
            operator: any_of
          }
        ]
      }
    ) {
      items {
        id
        name
      }
    }
  }
}

const mondayApiClient = new ApiClient({ token: myToken });

const query = `query ($board_id: [ID!], $column_id: ID!, $operator: ItemsQueryRuleOperator!, $compare_value:CompareValue!) { boards (ids: $board_id) { items_page (query_params: {rules: [{column_id: $column_id, compare_value: $compare_value,  operator:$operator}]}) { items { id name } } } }`;
const variables = {
  board_id: 9571351437,
  column_id: "date_mksr13fh",
  compare_value: ["EXACT", "2025-07-16"], 
  operator: "any_of",
};

const response = await mondayApiClient.request(query, variables);

This example shows how to filter a date column with multiple compare values.

query {
  boards(ids: [1234567890]) {
    items_page(
      query_params: {
        rules: [
          {
            column_id: "date4"
            compare_value: [
              "EXACT"
              "2024-09-10"
              "TODAY"
              "EXACT"
              "2024-09-11"
              "TOMORROW"
            ]
            operator: any_of
          }
        ]
      }
    ) {
      items {
        id
        name
      }
    }
  }
}

const mondayApiClient = new ApiClient({ token: myToken });

const query = `query ($board_id: [ID!], $column_id: ID!, $operator: ItemsQueryRuleOperator!, $compare_value:CompareValue!) { boards (ids: $board_id) { items_page (query_params: {rules: [{column_id: $column_id, compare_value: $compare_value,  operator:$operator}]}) { items { id name } } } }`;
const variables = {
  board_id: 9571351437,
  column_id: "date_mksr13fh",
  compare_value: ["EXACT", "2025-07-16", "TODAY", "TOMORROW"], 
  operator: "any_of",
};

const response = await mondayApiClient.request(query, variables);

This example returns all items on board 1234567890 with a date column value that is in the current week or after (based on the user making the API call).

query {
  boards(ids: [1234567890]) {
    items_page(
      query_params: {
        rules: [
          {
            column_id: "date"
            compare_value: ["THIS_WEEK"]
            operator: greater_than_or_equals
          }
        ]
      }
    ) {
      items {
        id
        name
      }
    }
  }
}

const mondayApiClient = new ApiClient({ token: myToken });

const query = `query ($board_id: [ID!], $column_id: ID!, $operator: ItemsQueryRuleOperator!, $compare_value:CompareValue!) { boards (ids: $board_id) { items_page (query_params: {rules: [{column_id: $column_id, compare_value: $compare_value,  operator:$operator}]}) { items { id name } } } }`;
const variables = {
  board_id: 9571351437,
  column_id: "date_mksr13fh",
  compare_value: ["THIS_WEEK"], 
  operator: "greater_than_or_equals",
};

const response = await mondayApiClient.request(query, variables);

This example returns all items on board 1234567890 that are not marked as "Done" in the status column and have a date column value that has not yet passed.

query {
  boards(ids: [1234567890]) {
    items_page(
      query_params: {
        rules: [
          {
            column_id: "date"
            compare_value: ["UPCOMING"]
            operator: any_of
          }
        ]
      }
    ) {
      items {
        id
        name
      }
    }
  }
}

const mondayApiClient = new ApiClient({ token: myToken });

const query = `query ($board_id: [ID!], $column_id: ID!, $operator: ItemsQueryRuleOperator!, $compare_value:CompareValue!) { boards (ids: $board_id) { items_page (query_params: {rules: [{column_id: $column_id, compare_value: $compare_value,  operator:$operator}]}) { items { id name } } } }`;
const variables = {
  board_id: 9571351437,
  column_id: "date_mksr13fh",
  compare_value: ["UPCOMING"], 
  operator: "any_of",
};

const response = await mondayApiClient.request(query, variables);

Update a date column

You can update a date column using the change_simple_column_value mutation and sending a simple string in the value argument. You can also use the change_multiple_column_values mutation and pass a JSON string in the column_values argument.

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 it in HH:MM:SS format with a space between the date and time. (Make sure to enter the date and time in UTC, so it will be converted to the user's timezone when they look at the board!)

mutation {
  change_simple_column_value(
    item_id: 9876543210
    board_id: 1234567890
    column_id: "date"
    value: "2019-06-03 13:25:00"
  ) {
    id
  }
}

import { ApiClient } from "@mondaydotcomorg/api";
const mondayApiClient = new ApiClient({ token: myToken });

const query = `mutation ($myBoardId:ID!, $myItemId:ID!, $myColumnValue: String!, $myColumnId: String!) { change_simple_column_value (item_id:$myItemId, board_id:$myBoardId, column_id: $myColumnId, value: $myColumnValue) { id } }`;
const variables = {
  myBoardId: 9571351437,
  myItemId: 9571351485,
  myColumnId: "date_mksr13fh",
  myColumnValue: "2025-08-27 13:00:00",
};

const response = await mondayApiClient.request(query, variables);

JSON

To update a date column with JSON, send a JSON string with a date and time key (optional). The date should also be in YYYY-MM-DD format, and the time in HH:MM:SS format. (Make sure to enter the date and time in UTC, so it will be converted to the user's timezone when they look at the board!)

mutation {
  change_multiple_column_values(
    item_id: 9876543210
    board_id: 1234567890
    column_values: "{\"date\":{\"date\":\"1993-08-27\",\"time\":\"18:00:00\"}}"
  ) {
    id
  }
}

const mondayApiClient = new ApiClient({ token: myToken });

const query = `mutation ($myBoardId:ID!, $myItemId:ID!, $myColumnValues:JSON!) { change_multiple_column_values(item_id:$myItemId, board_id:$myBoardId, column_values: $myColumnValues) { id } }`;
const variables = {
  myBoardId: 9571351437,
  myItemId: 9571351485,
  myColumnValues: JSON.stringify({ // date_mksr13fh is the column ID
    date_mksr13fh: {
      date: "1993-08-27",
      time: "05:20:00"
    } 
  }),
};

const response = await mondayApiClient.request(query, variables);

Clear a date column

You have two options to clear a date column. First, you can use the change_multiple_column_values mutation and pass null, an empty string, or an empty object in the column_values argument.

mutation {
  change_multiple_column_values(
    item_id: 9876543210
    board_id: 1234567890
    column_values: "{\"date\": null}"
  ) {
    id
  }
}

import { ApiClient } from "@mondaydotcomorg/api";

const query = `mutation ($myBoardId:ID!, $myItemId:ID!, $myColumnValues:JSON!) { change_multiple_column_values(item_id:$myItemId, board_id:$myBoardId, column_values: $myColumnValues) { id } }`;
const variables = {
  myBoardId: 9571351437,
  myItemId: 9571351485,
  myColumnValues: JSON.stringify({
    date_mksr13fh: null // date_mksr13fh is the column ID
  }),
};

const response = await mondayApiClient.request(query, variables);

You can also use the change_simple_column_value mutation and pass an empty string in the value argument.

mutation {
  change_simple_column_value(
    item_id: 9876543210
    board_id: 1234567890
    column_id: "date"
    value: ""
  ) {
    id
  }
}

import { ApiClient } from "@mondaydotcomorg/api";

const query = `mutation ($myBoardId:ID!, $myItemId:ID!, $myColumnValue: String!, $myColumnId: String!) { change_simple_column_value (item_id:$myItemId, board_id:$myBoardId, column_id: $myColumnId, value: $myColumnValue) { id } }`;
const variables = {
  myBoardId: 9571351437,
  myItemId: 9571351485,
  myColumnId: "date_mksr13fh",
  myColumnValue: "",
};

const response = await mondayApiClient.request(query, variables);