MySQL Forums
Forum List  »  Stored Procedures

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date
Posted by: Peter Brawley
Date: March 09, 2019 09:00PM

Given that you're using a database and sql, by far the simplest solution is to maintain a calendar table with a row for every day in the relevant range, then simply count rows between days excluding weekend days & holidays.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.