Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Whiteline.
Thanks. It works fine.