Jim Dettman
jimdettman at verizon.net
Mon Oct 8 12:59:07 CDT 2007
Joe, To thoroughly test, make sure you try your calc for the next 7 years forward. I think where your going to run into trouble is with either the start or end of the year, as they may not be full weeks. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas Sent: Monday, October 08, 2007 1:46 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com