[AccessD] Every other Friday

Hi David,

You might create a formula of some kind using Julian dates.  With these
dates the days of the year are numbered 1 - 365 (or 1 - 366).  Luckily, each
week is 7 days, so some math might do the trick.

I copied this function from an Access forum:

Function CDate2Julian(MyDate As Date) As String
    CDate2Julian = Format(MyDate - DateSerial(Year(MyDate) - 1, 12, 31),
"000")
End Function

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, February 21, 2013 1:23 PM
To: Access Developers discussion and problem solving
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
Website: http://www.databaseadvisors.com