Date range filter not including the last date on the selected range

[roebrich]

Hello Experts,

My project is currently in the testing phase and the testers have raised a bug about our dashboard not showing the last date selected on the date range filter. I attached a sample file to help with the resolution of this. For example, select a date range of 8/21/2017 to 8/28/2017, you will notice on the table on the right that when you scroll to the bottom 8/28/2017 is not on the list. Change the date range to 8/21/2017 to 8/29/2017, now you will see records for 8/28/2017. The issue is not limited to those specific dates, it also happens on other dates.

Thank you so much in advance.

[sunny_talwar · Accepted solution]

The problem is that you date is a timestamp and I am guessing when you select 8/29/2017, it is the beginning of the day, i.e., 8/29/2017 00:00:00 instead of 8:29:2017 23:59:59.... so anything you have on 8:29:2017 is not getting selected.... may be create a new field in the script where you truncate the time portion using Floor() function

Floor([Opening At]) as [Floored Opening At]

[sunny_talwar]

Check the attached

[roebrich]

Thank you so much. I applied the new field only on the date range slider but kept the timestamp on the table. So far looks like it is working.