Forum Discussion
Include empty date values in table when changing date slider
Hi All, I have a field called "NEXT_REVIEW_DATE" which is of date datatype. I am using this field as a range slicer. There are few records with empty date value for "NEXT_REVIEW_DATE" . Wh...
some_bih : As I am having limitations to access to upload files outside f client network, I am pasting sample data here.
NEXT_REVIEW_DATE is the field used in the slicer.
Sample screenshot:Whe, I change the slider , along with the selected dates, I should also be able to get the records with no dates as well.
Hope these details will help to replicate the issue.
KEY CT_DATE STATUS Duration DUE TOTAL EXPIRES % USED LAST_REVIEW_DATE NEXT_REVIEW_DATE 200635194 6/15/2022 0:00 Active 7 0 109551.19 5/30/2023 0:00 73.03% 601139617 6/15/2004 0:00 Active 14 0 1510.28 75.51% 601484357 7/12/2010 0:00 Active 21 0 36857.27 8/28/2022 0:00 73.71% 2/28/2023 0:00 601524082 5/5/2011 0:00 Active 21 243.91 396.13 99.03% 601682696 4/29/2014 0:00 Active 21 0 27885.88 79.67% 2/28/2023 0:00 601733618 11/6/2014 0:00 Active 21 0 17637.81 70.55% 6/30/2022 0:00 601970197 5/23/2017 0:00 Active 14 0 18503.89 74.02% 5/31/2022 0:00 601981626 6/21/2017 0:00 Active 14 0 39572.5 11/7/2022 0:00 79.15% 2/28/2023 0:00 602075015 3/1/2018 0:00 Active 14 0 33399.61 74.22% 9/16/2022 0:00 1/31/2023 0:00 602075283 3/5/2018 0:00 Active 14 0 18270.34 73.08% 3/31/2023 0:00 602304971 9/10/2019 0:00 Active 14 0 21700.97 86.80% 1/31/2023 0:00 602322006 11/18/2019 0:00 Active 21 0 63385.44 97.52% 8/31/2022 0:00 602342303 3/2/2020 0:00 Temporary Close 14 0 5105.68 102.11% 7/31/2021 0:00 602357379 5/15/2020 0:00 Permanent Close 21 38524.93 75293.37 5/23/2022 0:00 100.39% 3/31/2022 0:00 602373348 8/24/2020 0:00 Active 14 0 1509.05 75.45% 6/30/2022 0:00 602424344 5/24/2021 0:00 Active 21 0 59300.76 6/30/2022 0:00 79.07% 602456321 10/13/2021 0:00 Permanent Close 14 2193.95 2263.95 113.20% 602469194 12/14/2021 0:00 Active 14 0 1408.9 70.45% 11/30/2022 0:00 3/31/2023 0:00 602481285 2/17/2022 0:00 Active 14 0 3536.07 70.72% 3/31/2023 0:00 602522226 8/2/2022 0:00 Temporary Close 21 84255.57 84290.57 1/13/2023 0:00 84.29% 602530958 9/2/2022 0:00 Permanent Close 14 1963.21 2033.21 101.66% 602532487 9/5/2022 0:00 Active 21 0 36069.97 72.14% 602540988 10/7/2022 0:00 Active 14 0 4129.52 82.59% 602543114 10/13/2022 0:00 Active 14 0 3656.91 73.14% 602548148 11/8/2022 0:00 Active 14 0 3657.48 73.15% 602561281 1/18/2023 0:00 Active 14 0 1412.03 70.60% 602564002 2/1/2023 0:00 Permanent Close 14 2045.93 4262.6 85.25% 602568822 2/27/2023 0:00 Permanent Close 14 4426.01 4461.01 89.22% 602568871 2/27/2023 0:00 Permanent Close 14 2216.08 2286.08 114.30%
