Subtracting dates giving work days only
Has anyone encountered the following challenge and came up with a solution?
I need to report the duration of a service request in work days.
For that I need to use a TimestampDiff function to extract the opened time from the closed time giving a number of days.
However, that will give me the total number of days, including weekends.
The challenge is how to come up with a result where the weekends are disregarded.
Example: opened time is on a Friday and closed time is on the following Monday.
The TimestampDiff will result in 3 days but I need the result to be 1 day.