-
In the mortgage business certain activity must take place within a specific number of business days from the loan origination date. The purpose of this assignment is to develop a function that will calculate the business date ‘x’ number of days from a specific start date. For example: 10 Business days from August 25th, 2003 is September 8th, 2003.This function is to have a two input parameters, consisting of the start date in the format mm/dd/yyyy and the number of days to advance. The return value of the function is to be the calculated business date in the format mm/dd/yyyy. Non-business days for 2003 & 2004 must also be taken into consideration· Saturdays & Sundays· New Year’s Day · Memorial Day · July 4 · Labor Day · Thanksgiving · Christmas
Vasantha N
- Jun 12th, 2009
You need to access the database where the holiday details are stored.From current date increment by one. Check if the date is present in the holiday list.If yes keep the business date counter same.Else if no increment the business date counter. Repeat for the no of business date req.
