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="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>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy