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

About 4 years ago I tried to write a function to determine a 4-4-5 calendar.  What I ran into is the business continuously had to adjust the calendar here and there to account for each year...even though they claimed, "Its easy...4-4-5,,,see>?"...then when I showed them the following year's dates...."Oh?>?>?...we just change that week...that doesn't count."
 
Being that this type of accounting is constantly evolving...I vote for a table that lists every date for the next 5 years...and just tell it what fiscal month/week/year it belongs to.
 
Mark A. Matte> Date: Mon, 8 Oct 2007 13:59:07 -0400> From: jimdettman at verizon.net> To: accessd at databaseadvisors.com> Subject: Re: [AccessD] Calculating End of Month on a 4-4-5 Schedule> > 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> > -- > AccessD mailing list> AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com
_________________________________________________________________
Climb to the top of the charts!  Play Star Shuffle:  the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct