[AccessD] Every other Friday

Just remember that Access and Excel have different starting dates in their
engines ... unless MS sneaked one in on me in the latest version.

Charlotte

On Thu, Feb 21, 2013 at 11:41 AM, James Button <jamesbutton at blueyonder.co.uk
> wrote:

> (Excel solution)
> date - being stored as days from 1st Jan 1900 means that day 1 was a Sunday
> so mod(today(),14) will give 0 and 7 for Saturdays
> add 1 - as in   mod(Theday+1,14) and you get the 0 and 7 for Fridays
> now 22nd Feb 2013 wants the 1 added to get the MOD to return 0
>
> How you get the date to be checked, and use the result is up to you
>
> JimB
>
> ----- Original Message ----- From: "David McAfee" <davidmcafee at gmail.com>
> To: "Access Developers discussion and problem solving" <
> accessd at databaseadvisors.com>
> Sent: Thursday, February 21, 2013 7:23 PM
> Subject: [AccessD] Every other Friday
>
>
>  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<http://databaseadvisors.com/mailman/listinfo/accessd>
>> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>