Business Logic Previous Day when Dates are discrete

abhaysingh0402 — Fri, 15 Nov 2024 20:58:45 GMT

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

Re: Business Logic Previous Day when Dates are discrete

musketeers — Tue, 07 May 2024 16:11:45 GMT

hi, please check if below discussion helps u