Solved: Worksday in a date difference - Qlik Community

Anonymous · ‎2012-09-25

Dear All,

I need to count the number of work days (no staurdays and sundays) in a difference of two dates. Please help with this expression.

In SQL... datediff('dw',date1,date2)

Thanks in advance.

André Rodrigues

whiteline · ‎2012-09-25

Hi.

You could use function networkdays().

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.

Or calculate it manually, it's not so hard.

View solution in original post

whiteline · ‎2012-09-25

Hi.

You could use function networkdays().

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.

Or calculate it manually, it's not so hard.

Anonymous · ‎2012-09-25

Whiteline.

Thanks. It works fine.