如何过滤数据表中的日期范围? [英] How do I filter date range in DataTables?

问题描述

我有一个包含乘车信息的大型数据表.每行都有以下格式的开始日期时间和结束日期时间(yyyy-mm-dd HH:mm:ss).如何使用日期选择器在数据表中设置过滤器范围?我想要一个日期选择器，它只选择一天而不是时间.我到处寻找正确的答案，但我找不到.预先感谢您的帮助.

I have a large dataTable which contains ride information. Every row has a start datetime and an end datetime of the following format(yyyy-mm-dd HH:mm:ss). How can I use a datepicker for setting a filter range in dataTables? I want to have a datepicker which only selects a day and not the time. I've searched everywhere for the proper answer but I couldn't find it. Thanks in advance for helping.

例如，我想通过选择 (01-07-2016 - 31-07-2016) 来查看 7 月的所有行.

For example I want to see all rows of July by selecting (01-07-2016 - 31-07-2016).

推荐答案

Here is DataTable with Single DatePicker as "from" Date Filter

Here is DataTable with Single DatePicker as "from" Date Filter

现场演示

这里是 DataTable 带有两个 DatePickers 用于 DateRange(To 和 From)过滤器

Here is DataTable with Two DatePickers for DateRange (To and From) Filter

现场演示

这篇关于如何过滤数据表中的日期范围?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！