---
title: "Date Cell Editors"
framework: javascript
version: "36.1.0"
---

# Date Cell Editors

Two date cell editors are provided - `agDateCellEditor` for cell values provided as [Date](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date), and `agDateStringCellEditor` for date values provided as [String](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String).

## Enabling Date Cell Editor

Edit any of the cells in the grid below to see the Date Cell Editor.

#### Date Editor

```ts
import {
  ClientSideRowModelModule,
  ColDef,
  DateEditorModule,
  GridApi,
  GridOptions,
  ModuleRegistry,
  ValueFormatterParams,
  createGrid,
  enableDevValidations,
} from "ag-grid-community";

// Enable extended validations only for development
if (process.env.NODE_ENV !== "production") {
  enableDevValidations();
}

ModuleRegistry.registerModules([ClientSideRowModelModule, DateEditorModule]);

const columnDefs: ColDef[] = [
  {
    headerName: "Date Editor",
    field: "date",
    valueFormatter: (params: ValueFormatterParams<any, Date>) => {
      if (!params.value) {
        return "";
      }
      const month = params.value.getMonth() + 1;
      const day = params.value.getDate();
      return `${params.value.getFullYear()}-${month < 10 ? "0" + month : month}-${day < 10 ? "0" + day : day}`;
    },
    cellEditor: "agDateCellEditor",
  },
];

const data = Array.from(Array(20).keys()).map((val: any, index: number) => ({
  date: new Date(2023, 5, index + 1),
}));

let gridApi: GridApi;

const gridOptions: GridOptions = {
  defaultColDef: {
    width: 200,
    editable: true,
  },
  columnDefs: columnDefs,
  rowData: data,
};

const gridDiv = document.querySelector<HTMLElement>("#myGrid")!;
gridApi = createGrid(gridDiv, gridOptions);
```

[Live example: Date Editor](https://www.ag-grid.com/examples/provided-cell-editors-date/date-editor/typescript)

The Date Cell Editor is a simple date editor that uses the standard HTML date input and requires cell values to be of type [Date](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date).

Enabled with `agDateCellEditor` and configured with `IDateCellEditorParams`.

```js
columnDefs: [
    {
        cellEditor: 'agDateCellEditor',
        cellEditorParams: {
            min: '2000-01-01',
            max: '2019-12-31',
        }
        // ...other props
    }
]
```

### API Reference

Properties available on the `IDateCellEditorParams&lt;TData = any, TContext = any&gt;` interface.

| Property | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| `min` | `string \| Date` |  |  | Min allowed value. Either `Date` object or string in format `'yyyy-mm-dd'`. |
| `max` | `string \| Date` |  |  | Max allowed value. Either `Date` object or string in format `'yyyy-mm-dd'`. |
| `step` | `number` |  |  | Size of the value change when stepping up/down, starting from `min` or the initial value if provided. Step is also the difference between valid values. If the user-provided value isn't a multiple of the step value from the starting value, it will be considered invalid. Defaults to any value allowed. |
| `includeTime` | `boolean` |  | `false` | Defines whether time should be included when editing dates. `true`: Date and time will be editable. `false`: Only date portion will be editable. |

## Enabling Date as String Cell Editor

Edit any of the cells in the grid below to see the Date as String Cell Editor.

#### Date as String Editor

```ts
import {
  ClientSideRowModelModule,
  ColDef,
  DateEditorModule,
  GridApi,
  GridOptions,
  ModuleRegistry,
  createGrid,
  enableDevValidations,
} from "ag-grid-community";

// Enable extended validations only for development
if (process.env.NODE_ENV !== "production") {
  enableDevValidations();
}

ModuleRegistry.registerModules([ClientSideRowModelModule, DateEditorModule]);

const columnDefs: ColDef[] = [
  {
    headerName: "Date as String Editor",
    field: "dateString",
    cellEditor: "agDateStringCellEditor",
  },
];

const data = Array.from(Array(20).keys()).map((val: any, index: number) => ({
  dateString: `2023-06-${index < 9 ? "0" + (index + 1) : index + 1}`,
}));

let gridApi: GridApi;

const gridOptions: GridOptions = {
  defaultColDef: {
    width: 200,
    editable: true,
  },
  columnDefs: columnDefs,
  rowData: data,
};

const gridDiv = document.querySelector<HTMLElement>("#myGrid")!;
gridApi = createGrid(gridDiv, gridOptions);
```

[Live example: Date as String Editor](https://www.ag-grid.com/examples/provided-cell-editors-date/date-as-string-editor/typescript)

The Date as String Cell Editor is a simple date editor that uses the standard HTML date input. It's similar to the Date Cell Editor, but works off of cell values with type [String](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String).

The date format is controlled via [Cell Data Types](https://www.ag-grid.com/javascript-data-grid/cell-data-types/) and the [Date as String Data Type Definition](https://www.ag-grid.com/javascript-data-grid/cell-data-types/#date-as-string). The default is `'YYYY-MM-DD'` (or `'YYYY-MM-DDTHH:mm:ss'` for `dateTimeString`).

Enabled with `agDateStringCellEditor` and configured with `IDateStringCellEditorParams`.

```js
columnDefs: [
    {
        cellEditor: 'agDateStringCellEditor',
        cellEditorParams: {
            min: '2000-01-01',
            max: '2019-12-31',
        }
        // ...other props
    }
]
```

### API Reference

Properties available on the `IDateStringCellEditorParams&lt;TData = any, TContext = any&gt;` interface.

| Property | Type | Required | Default | Description |
| --- | --- | --- | --- | --- |
| `min` | `string \| Date` |  |  | Min allowed value. Either `Date` object or string in format `'yyyy-mm-dd'`. |
| `max` | `string \| Date` |  |  | Max allowed value. Either `Date` object or string in format `'yyyy-mm-dd'`. |
| `step` | `number` |  |  | Size of the value change when stepping up/down, starting from `min` or the initial value if provided. Step is also the difference between valid values. If the user-provided value isn't a multiple of the step value from the starting value, it will be considered invalid. Defaults to any value allowed. |
| `includeTime` | `boolean` |  | `false` | Defines whether time should be included when editing dates. `true`: Date and time will be editable. `false`: Only date portion will be editable. |