Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]
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]
Check the attached
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.