Discussion board where members can get started with Qlik Sense.
Hi i have 2 dates , start_date and end_date for the month of November , i am trying to find the difference between these 2 dates excluding weekends ( ie Saturday and Sunday).
If u can provide example it will be great, i am using qliksense
Go to Solution.
Can u try :
end_date -start_date -( 2*(round((end_date -start_date )/7)))
=> 19 days
date('29/01/2018')-date('02/01/2018')-( 2*(round((date('29/01/2018')-date('02/01/2018'))/7))) +1
=> 20 days
Use NetWorkDays() function
networkdays - script and chart function ‒ Qlik Sense
But why this Omar, did I missing something from the initial post? Why can't we use NetWorkDays() here?
NetworkDays already eliminates the weekends? Didn't know that sorry !
It does, and I am amazed you have never used or heard about this function? Don't have to be sorry for anything, we are all learning new things... this is something new for you
thanks for your help and the link , it really helped in learning new syntax as well
THis one really worked.
Thanks for all ur support and time