Forum Discussion
Solved
How to get opening date
my data has 3 dates(01-01-2023,02-01-2023,03-01-2023) in row but user select slicer in date between (02-01-2023 to 03-01-2023) then 01-01-2023 has to show 'opening' else 02-01-2023, 03-01-2023 in pow...
pls see the attachment below
Appreciate your kudos. if my solution is helpful, pls mark it as an accepted solution. Thanks
Hi danextian ,
My slicer have between dates, i select some between dates my table docdate have to show less than of my date values show "opening" rest all have to show between dates,i attached screen shot for you reference.
Thanks.
Hi arun90 ,
Going back to my question and basing on your screenshot, what date/dates are you expecting to appear in Opening Date column?
Hi danextian
If the document date is prior to January 31, 2024, the opening date column should display "Opening"; otherwise, it should display the dates between January 31, 2024, and March 5, 2024, as per the selected slicer period.
Thanks.