<pre>
Kendoui grid date filterable "Is equal to" - Make it have a range base on what is input
If you have a date column in a grid and you filter it
and select "Is equal to"
it currently doesn't work very good unless your dates/time
are all on 12:00:00.000 AM
Maybe you could make the filter do this when "Is equal to"
If you select or inputput:
2/22/2004
It will find the following rows:
02/22/2004 00:00:00.000 <= datesFound < 02/23/2004 00:00:00.000
2/22/2004 06:
It will find the following rows:
02/22/2004 06:00:00.000 <= datesFound < 02/23/2004 07:00:00.000
2/22/2004 06:50
It will find the following rows:
02/22/2004 06:50:00.000 <= datesFound < 02/23/2004 07:51:00.000
2/22/2004 06:50:20
It will find the following rows:
02/22/2004 06:50:20.000 <= datesFound < 02/23/2004 07:51:21.000
2/22/2004 06:50:20.034
It will find the following rows:
02/22/2004 06:50:20.034 <= datesFound < 02/23/2004 07:51:21.035
Maybe have a toggle for (0-12 AM/PM) or (00-23 24 hour clock)
in the datetimepicker with a default setting that can be configured.
Maybe make the datetimepicker have a range for each
Hour, minute, second, millisecond, AM/PM
* or blank - could act like a regular expression but would need to have the
higher unit set. IE: (
06:50:20.035 , 06:50:20.* , 06:50:*.* , 06:*:*.* , *:*:*.*
or
6:50:20.035 AM, 6:50:20.* AM, 6:50:*.* AM, 6:*:*.* AM, *:*:*.* *
Not this:
*:50:*.* *
).
HH , MM , ss , fff
00-23;*, 0-59;*, 0-59;*, 000 - 999;*
or
H , tt , MM , ss , fff
0-12;* , AM/PM;*, 0-59;*, 0-59;*, 000 - 999;*
The yyyy,MM,dd could also be done this way so you could get all the rows
for a yyyy****, yyyyMM**, yyyyMMdd
</pre>