Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

Similar script function to lastworkdate

I'm using lastworkdate in my script to work out X working days before my start date. However I've been told for some countries in my data the working week is Mon-Sat (not Mon-Fri). How can I do this? I've got a calendar and can easily get a list of all Sundays and Holidays to put in a variable take away from my start date, if only there's some way to take X days from my start excluding the dates in the list. 

Labels (1)
0 Replies