12-24-2008, 12:49 AM
I need to calculate funds that will be available a certain number of business days (Mon-Fri and non-holidays)
I guess the business days would be easy to figure out if SYSTEMTIME st.wDayOfWeek does not equal 0 or 6...but holidays? I figure a list would of dates would work...is there a database or something that has US Bank holidays?
What would be the best way to go about this?
Essentially I'll be calculating available funds deposited based on different types of payment types Cash=0 business days, Checks=5 business days, and Credit Cards=3 business days. That way I'll be able to click a button in my program and get how much I have available right now and how much I have pending. It will save me a phone call to the bank everytime I want to put in an order with a distributor.
Thanks,
Jimmy Vig
I guess the business days would be easy to figure out if SYSTEMTIME st.wDayOfWeek does not equal 0 or 6...but holidays? I figure a list would of dates would work...is there a database or something that has US Bank holidays?
What would be the best way to go about this?
Essentially I'll be calculating available funds deposited based on different types of payment types Cash=0 business days, Checks=5 business days, and Credit Cards=3 business days. That way I'll be able to click a button in my program and get how much I have available right now and how much I have pending. It will save me a phone call to the bank everytime I want to put in an order with a distributor.
Thanks,
Jimmy Vig