[AccessD] is this date affected?

Gustav Brock gustav at cactus.dk
Sat Apr 16 10:59:22 CDT 2011


Hi David

You can build a collection of the dates using a loop and DateAdd.
Then look up your date in this collection.

/gustav


>>> davidmcafee at gmail.com 16-04-2011 01:35 >>>
I was wondering if anyone already has some code or Jet SQL to determine if a
date is affected?

Such as  Every other Saturday for the next x Saturdays starting 4/16/2011
(2011.04.16 ;)  )

Is 4/30/2011 one of those saturdays?  (Yes)
Is May 7th? (no)

I was going to write a function, but I was wondering I am re-inventing the
wheel, or if there is some built in too to do so.


Thanks,
David





More information about the AccessD mailing list