View Full Version : Best way to filter date/time columns to an entire day?

12 Mar 2018, 6:40 AM
I am looking for the optimal way to implement a date(day = x) filter on a field that is date with time.

The stock filters work for Before and After but the On filter does not because a date never equals a date time. EG: "01-01-2018 <> 01-01-2018 14:10:10" A date time filter is too specific as I want the entire day. What is the best way to implement a grid filter so that the On selection will match against all timestamps on that day regardless of time but still display the date with time? My data is a postgresql timestamp without time zone..

My current fix is to manually convert eq filters to date ranges on the server side but that does not scale well and is likely to create regression errors.

Extjs 4.2 with Cakephp 2.