[AccessD] Every other Friday

David McAfee davidmcafee at gmail.com
Thu Feb 21 15:30:14 CST 2013


I guess this works:

IF datediff("d",StartDate, DateInQuestion) Mod 14 = 0 THen True


? datediff("d",#2/22/13#, #8/16/13#) Mod 14
7 So it's a Friday, but not a Furlough Friday.

I agree with Gary in setting up a table, but I was trying to come up with a
quick and dirty answer.

Thanks,
David


On Thu, Feb 21, 2013 at 11:56 AM, Dan Waters <df.waters at comcast.net> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list