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