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