Edit this page

filterable.operators.date Object

The texts of the filter operators displayed for columns bound to date fields.

Omitting an operator will exclude it from the DropDownList with the available operators.

Example - set date operators

<div id="treelist"></div>
    columns: [
      { field: "lastName" },
      { field: "position" },
      { field: "hireDate", format: "{0:MM/dd/yyyy}" }
    dataSource: {
      data: [
        { id: 1, parentId: null, lastName: "Jackson", position: "CEO", hireDate: new Date() },
        { id: 2, parentId: 1, lastName: "Weber", position: "    VP, Engineering", hireDate: new Date() }
      schema: {
        model: {
          fields: {
            hireDate: { type: "date" }
    filterable: {
      extra: false,
      operators: {
        date: {
          lt: "Is before...",
          gt: "Is after..."

In this example only two operators will be displayed in the operators DropDownList - "Is before..." and "Is after...".

filterable.operators.date.eq String (default: "Is equal to")

The text of the eq (equal to) filter operator.

filterable.operators.date.neq String (default: "Is not equal to")

The text of the ne (not equal to) filter operator.

filterable.operators.date.isnull String (default: "Is null")

The text of the isnull filter operator.

filterable.operators.date.isnotnull String (default: "Is not null")

The text of the isnotnull filter operator.

filterable.operators.date.gte String (default: "Is after or equal to")

The text of the gte (greater than or equal to) filter operator.

filterable.operators.date.gt String (default: "Is after")

The text of the gt (greater than) filter operator.

filterable.operators.date.lte String (default: "Is before or equal to")

The text of the "lte" (less than or equal to) filter operator.

filterable.operators.date.lt String (default: "Is before")

The text of the lt (less than) filter operator.

Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article