Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
mdmukramali
Specialist III
Specialist III

DURATION BY EXCLUDING WEEKDAYS AND HOLIDAYS

Dear All,

In My table i have REQUEST_NO ,REQUEST_START_DATE AND REQUEST_END_DATE .

By using Interval match function i calculated the DURATION to complete the REQUEST.

but i want to exclude the Weekdays from DURATION.  in my case Friday and Saturday are weekdays (holidays) . Sunday is the first day of my week.

I tried Networkdays() function but i didn't succeed to achieve the desired result.

Kindly find the attached sample file,

please help me to solve the my problem.

Thanks,

Mukram.

1 Reply
maxgro
MVP
MVP

maybe with networkdays(REQUEST_START_DATE+1, REQUEST_END_DATE+1)

+1 to adapt your weekdays (friday and saturday) to "standard" (saturday and sunday) weekdays