September 13th, 2013, 11:18 AM
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, 11:25 AM
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, 11:58 AM
I see... let me try that out. Thank you for the quick response!