Increment Dates

[Guest]

Hi. We typically run classes on Mondays and Wednesdays or Tuesdays and
Thursdays from [Start Date] to [Test Date]. How would one go about designing
a query to return those dates in between, excluding holidays? For example:
Session #1 - Mon. 8/29/05; Session #2 - Wed. 8/31/05; Session #3 - Wed.
9/7/05 (as Mon. 9/5/05 is Labor Day -- No classes held); and so on.

Would it be helpful to indicate the number of sessions and perhaps a lookup
table of holidays to exclude?

Any suggestions would be greatly appreciated.

Thanks, --Al.

 

[John Vinson]

Hi. We typically run classes on Mondays and Wednesdays or Tuesdays and
Thursdays from [Start Date] to [Test Date]. How would one go about designing
a query to return those dates in between, excluding holidays? For example:
Session #1 - Mon. 8/29/05; Session #2 - Wed. 8/31/05; Session #3 - Wed.
9/7/05 (as Mon. 9/5/05 is Labor Day -- No classes held); and so on.

Would it be helpful to indicate the number of sessions and perhaps a lookup
table of holidays to exclude?

Any suggestions would be greatly appreciated.

Thanks, --Al.

Well, you will certainly need a Holidays table - or, perhaps simpler,
a Sessions table with the actual dates stored in it.

What are your current tables' fields?

John W. Vinson[MVP]