Unanswered: Datediff in hours and exclude weekends
I have created a function that calculates the difference between 2 days in days.
ie. if Date 1 = May 2, 2008 and date 2 = May 5, 2008
Looking at this example the day difference = 3 days. Now my issue is how do I remove the weekends from this count so that the count in this example = 1 and not 3........?
the part of my logic that calculates Day is
IF DatePart = 'Day' OR DatePart = 'DAY' THEN
I want to keep everything the same and use my logic and code. Thanks.