Using SQL to calculate a date within a certain date range
- by David Passmore
Hi,
I'm using access 2007 and i am trying to set up a database to act as a library system, i need a function that automatically calculates a date 14 days after a given date i.e. Loan Date vs. Due Date. But the library is open only on certain Days. So i need the 14 days not to include the dates that are out of hours, like weekends and school holidays etc.
I think i need to use Select Case or IIF's?
Help would be appreciated!
Thanks
David