[AccessD] Calculating End of Month on a 4-4-5 Schedule

Good catch.
Either way the requirement stays the same.

I ended up using DateSerial to move to the beginning of the month, then
to the first Saturday, and then add 3 or 4 week accordingly.
Seems to work out well.

Joe Rojas
Information Technology Manager
Symmetry Medical TNCO
15 Colebrook Blvd
Whitman MA 02382
781.447.6661 x7506


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan,
Lambert
Sent: Monday, October 08, 2007 11:37 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Calculating End of Month on a 4-4-5 Schedule

-----Original Message-----
<snip>

If you look at a calendar, Jan, Feb, Apr, May, Jul, Aug, Oct, and Nov
only
have 4 Saturdays and the others have 5 Saturdays. The rational must be
buried in that fact.

<snip>

Not so, I'm afraid. The number of Saturdays in a month is not static. It
depends on what year you are looking at. For instance May 2008 has 5,
not 4.
June 2008 has 4, not 5.

Lambert
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com