[AccessD] is this date affected?

Hi David

Easier, yes, but it doesn't answer "such as  Every other Saturday for the next x Saturdays starting 4/16/2011".

/gustav


>>> davidmcafee at gmail.com 18-04-2011 19:52 >>>
Thanks AD, that's exactly what I was looking for!

I was thinking of doing something like Gustav suggested, but knew there had to be an easier way.



On Sat, Apr 16, 2011 at 8:57 PM, A.D. Tejpal <adtp at airtelmail.in> wrote:

> David,
>
>    Another alternative could be considered.
>
>    You wish to ascertain whether date Dt2 falls on one of the alternate
> Saturdays starting from Dt1 which is a Saturday.
>
>    If the test is to be reflected via a Boolean variable IsAffected, the
> following could be tried:
>
>    IsAffected = ((Dt2 - Dt1) Mod 14 = 0)
>
>    If the condition is to be checked in an If / End If block, the syntax
> could be as follows:
>
>    If (Dt2 - Dt1) Mod 14 = 0 Then
>
> Best wishes,
> A.D. Tejpal