Skip to Content
0
Jun 29, 2020 at 05:34 AM

Help required to calculate business dates in WEB I

30 Views

Hi All,


Require one help.

We have an transaction date comming from DB where data will be populated from Monday to saturday and holiday calander to be at report level where if dates fall on so and so holidays then will flag Y.
Now say on sunday there are no transaction then on saturda the date difference should be 2

For Ex:
Transaction dates Date Diff
22-June-2020 1
23-June-2020 1
...
26-June-2020 1
27-Jun-2020 3

30-June-2020

How ever if Monday is also holiday for example then on Saturday date difference should be 3.

Need to achive in WEB I , kindly guide