If you truly want only business days - i.e. you don't want to count Holidays - the only solution is to have a tables with all the business days. You'd populate this periodically with future dates as required, and a human may be required to mark off the holidays (unless you can create an algorithm that generically describes your company's Holidays - and they never change...).
Once you have that table, use a Count(*) on dates between a and b. HTH, Tore. ----- Original Message ----- From: "Lucas Cowgar" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 12:58 PM Subject: # of Business Days? > Can anyone out there help me with a SQL query? I need to find the number of > business days between date a and b? Obviously finding simply the number of > days is easy, but I have no clue how to find the number of business days. > TIA! > > > Lucas Cowgar > Information Technologies Department > Eldorado Services Group Inc. > http://www.eldoserv.com > [EMAIL PROTECTED] > (330) 861-3009 > > "All your base are belong to us" > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
