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

Hi Jim

Leery? I wonder why. A function like this will run in microseconds and begs to be wrapped into a callback function as source for your combo.

This is a general comment. That said, I still don't get how this 4-4-5 system should be used and calculated, and your comments about weeks at year end seem highly relevant.

/gustav

>>> jimdettman at verizon.net 08-10-2007 20:05 >>>

  Besides which with a lookup table, they can implement whatever type of
closing schedule they want (monthly or 4-4-5).  For myself, I've always used
a hybrid approach; I use a lookup table, but fill that table automatically
for them with what I believe to be the correct dates based on what they tell
me the last day of the week is and what schedule their using.  Finial check
then is up to them.

  I'd be leery of using a totally calculated approach.

Jim.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Monday, October 08, 2007 12:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Calculating End of Month on a 4-4-5 Schedule

I concur.  If you want the last Saturday of any month, I can do that in
one line of code, but this 4-4-5 thing is going to shift one day every
year (and 2 every leap year).  So eventually, you will end up with the
start of a fiscal month at the beginning of another month. (Take 2007,
if you say that 1-31-2007 is the end of the month, the beginning would
actually be 12-31-2006).  I'm good at math, but the 4 4 5 thing eludes
me how to come up with an equation to calculate it.  Seems like the most
efficient route would be to just build a look up table.

Drew

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


  It's a standard in the US financial community.  It's based on the fact
that the year needs to be divided up into 13 week quarters for
accounting,
yet the calendar varies.

  The way I typically see this implemented is a table containing the
last
(or first) fiscal date for each month, and the last day of the fiscal
year.
It's then easy to determine which month (and hence quarter) a given date
falls into.

Jim.