Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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

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