Hi,
I want to check a generic solution for Previous Day calculation when dates are Discrete.
in my case i am getting dates like below.
Now i want max date which is 10-05-2024. which can simply calculate by max(BusinessDate)
Previous Day = Should be 08-05-2024.
if i select any date, it should consider as Max Date.. and Previous Date should be last available date in data.
Say if i select 06-05-2024 then prev date should come 03-05-2024.
Please suggest.
TIA.
| 01-05-2024 |
| 02-05-2024 |
| 03-05-2024 |
| 06-05-2024 |
| 07-05-2024 |
| 08-05-2024 |
| 10-05-2024 |
