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="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        gt: "After",
        lt: "Before"
      }
    }
  }
});
</script>

In this example only two operators would be displayed in the DropDownList - "Equal to" and "Not equal to".

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

The text of the "equal" filter operator.

Example - set the date "equal" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        eq: "Equal"
      }
    }
  }
});
</script>

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

The text of the "not equal" filter operator.

Example - set the date "not equal" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        neq: "Not equal"
      }
    }
  }
});
</script>

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

The text of the "isnull" filter operator.

Example - set the date "isnull" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        isnull: "Null"
      }
    }
  }
});
</script>

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

The text of the "isnotnull" filter operator.

Example - set the date "isnotnull" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        isnotnull: "Null"
      }
    }
  }
});
</script>

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

The text of the "greater than or equal" filter operator.

Example - set the date "greater than or equal" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        gte: "After or equal to"
      }
    }
  }
});
</script>

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

The text of the "greater than" filter operator.

Example - set the date "greater than" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        gt: "After"
      }
    }
  }
});
</script>

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

The text of the "less than or equal" filter operator.

Example - set the date "less than or equal" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        lte: "Before or equal to"
      }
    }
  }
});
</script>

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

The text of the "less than" filter operator.

Example - set the date "less than" operator

<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "date", format: "{0:yyyy-MM-dd}" }
  ],
  dataSource: {
    data: [
      { date: kendo.parseDate("2000-10-10") },
      { date: new Date() }
    ],
    schema: {
      model: {
        fields: {
          date: { type: "date" }
        }
      }
    }
  },
  filterable: {
    operators: {
      date: {
        lt: "Before"
      }
    }
  }
});
</script>
In this article
Not finding the help you need?