September 13th, 2013, 12:18 PM
Date Diff Exclude Weekends as Select Only, No Function
Is there a way to do a date diff to exclude weekends without a function? I've searched the web but everything seems to require a function. Trying to do the date diff in a select statement.
Thanks for the help!
September 13th, 2013, 12:25 PM
yes, by joining to a calendar table (where calendar date between start date and end date), counting the non-weekend days
Originally Posted by kaneda0149
September 13th, 2013, 12:58 PM
I see... let me try that out. Thank you for the quick response!