Re: How do I setup Fiscal Yr to begin in October in Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mon, 18 Aug 2008 11:29:09 -0400, "Bob Barrows [MVP]"
<reb01501@xxxxxxxxxxxxxxx> wrote:

Bob Barrows [MVP] wrote:
Deb wrote:
I'm using 2003. I'm trying to set up a query for assessment testing
that is reported quarterly. The FY begins in October instead of Jan.
I have the quarter column set up for the beginning assessment date
but it is calculating from the system's current FY. I have columns
for Post Reading Date, Post Math Date, Post Language Date. I want
the quater column to reflect when the reporting data is due by the FY
beginning in October?

The easiest way is to use a calendar table

This was assuming that your fiscal weeks and months (FM) always begin on
Sunday, which is the case in my company. For example, in this scenario,
FM 1-2009 might begin on 5-Oct this year (or, depending on how the
accountants define it, 28-Sep). In this situation, simply adding 3
months to 1-Oct 2008, which should be in FM 12-2008, would result in the
wrong fiscal year and month (1-2009).

If your fiscal months always begin on the first of the calendar months,
then the solutions suggested by the other responders will work fine.

An excellent example of the need for the "It Depends" response! Businesses
handle these things diffrently, and clearly Bob's company will require a
different solution than the others. Deb should be sure that she's modeling the
company's actual business rules.
--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Possible bug in Calendar
    ... in providing the localized user interfaces, including selection of which business rules to apply, but in the core logic classes I *hope* your Dates are all represented in one particular time base and that when the chosen business rules say "x is three days after y" it just adds 3*86400*1000ms to some number somewhere under the hood. ... - people erroneously calculated intervals of days by multiplying 24 hours times the number of milliseconds in an hour. ... The advantage of Calendar, in this case GregorianCalendar, for all its flaws, is that it correctly calculates intervals like "three days after y", rather than by such a naive and incorrect means. ... Some years back I worked on a warehouse project where the client billed their customers according to the number of days their goods were in storage, but also gave special deals as incentives. ...
    (comp.lang.java.programmer)
  • Re: Relative time in SQL
    ... "Tom Ogilvy" wrote ... ... I had my suspicions. ... but additionally refers to their calendar table (their business rules ...
    (microsoft.public.excel.programming)
  • Re: Date query
    ... Just ignore this guy - the number of times he's been told the yyyy-mm-dd format is problematic and doesn't work across national boundaries is countless. ... holds your temporal data and business rules. ... the last calendar date of each month or the last business date of each ...
    (microsoft.public.sqlserver.programming)
  • Re: Extended-Range Time Type
    ... same calendric system can be calculated exactly, i.e., as if they ... business rules, at least from the ISO C library. ... open source libraries to provide calendar types for the most ...
    (comp.std.c)