Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression Date

Hello

Could somebody tell me which expression I have to use te make the difference between 2

dates in workdays ?

Thanks in advance.

Marc

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use the networkdays function

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

firstworkdate(end_date, no_of_workdays {, holiday} )


talk is cheap, supply exceeds demand
Not applicable
Author

Hi

Thank you for the information.

Marc