I have a custom DATE field called 'target_ship_date'
In the order grid, I use the adminhtml/widget_grid_column_filter_date and if I use the range 10/3/2017 to 10/4/2017 it returns all records that are >= 10/3/2017 and <= 10/4/2017.
If I use this widget as a filterable config setting for a custom report, it looks like it is returning records that are > 10/3/2017 and <= 10/4/2017. ie., only 10/4/2017
I have a custom DATE field called 'target_ship_date'
In the order grid, I use the adminhtml/widget_grid_column_filter_date and if I use the range 10/3/2017 to 10/4/2017 it returns all records that are >= 10/3/2017 and <= 10/4/2017.
If I use this widget as a filterable config setting for a custom report, it looks like it is returning records that are > 10/3/2017 and <= 10/4/2017. ie., only 10/4/2017
Is there a work around or is this a bug?