Script to calculate last 60 business days

[cramkumar86]

Hi,

I am trying to calculate last 60 business days from today()-1. Business days exclude Saturdays and Sundays. The below script does work for 60 calendar days. But how do I make it work for 60 business days?

Let vMaxDate = Date(today()-1);

Let vMinDate= Date(vMaxDate-60);

Please help.

Regards,

Ram

[JHuis]

Dont you want to calculate MaxDate minus 12 weeks? 

Then you could use Date($(vMaxDate)-84)

Thats also the same as 60 working days. 

[G3S]

this might be of help

https://community.qlik.com/t5/QlikView-App-Dev/Calculating-the-number-of-weekdays-from-the-beginning...

[Prem0212]

I think this expression will help you.

Date(today()-1)

Date(vMaxDate -83),

from today to calculate exactly 60 business days means 7 weeks which is 84 so that i have taken 83 for calculate from yesterday.

and to extract working 60 business days used Network days function.

Please like and accept the solution if u liked it.