[AccessD] Every other Friday

Note - my earlier answer does not take account of Good Friday - Xmas, and 
other holidays
Holidays mentioned are presuming that the calendar to be used is a 
'Christian' one!

JimB

----- Original Message ----- 
From: "Gary Kjos" <garykjos at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, February 21, 2013 7:31 PM
Subject: Re: [AccessD] Every other Friday


> In the data warehousing world we use a DATE TABLE for that kind of
> stuff.  I fought the concept at first but have since drank the Kool
> Aid and seen the light.
>
> GK
>
> On Thu, Feb 21, 2013 at 1:23 PM, David McAfee <davidmcafee at gmail.com> 
> wrote:
>> Okay, I have a question for the Access community :)
>>
>>
>> If every other Friday (starting Feb 22nd 2013) is a Furlough Friday 
>> (office
>> is closed), is there a way to determine if a given date such as August 
>> 16th
>> 2013 is available for a meeting?
>>
>> I'm thinking something to do with Mod 14 maybe?
>>
>> SQL or VBA answers are fine.
>>
>> Thanks in advance.
>>
>> David McAfee
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
>
> -- 
> Gary Kjos
> garykjos at gmail.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com