due date calculation excluding holidays and weekends

[arishsu]

Hi

I need to add a new column 'Due date' to a report. I have a 'Report DateTime' and due date needs to be calculated by adding 20 business days to report date time. But weekneds and national holidays must be excluded.

Can anyone please give me some suggestions?

[BigChris]

Weekends aren't too bad...you can work out how many days to add to the current date based on the day of the week. Can't think of a way to take out the national holidays though. The best option would be to create a calendar table in your database, and populate it with every date in one column and the required end date in the another. Whilst you're doing that you could add in any other dates that are relevant to your business, e.g. Fiscal Period Start Date, Fiscal Period End Date, Working Day, Working Days in Period, Working Days Elapsed in Period et. etc.