Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
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