Using Fiscal Years in my database

[akaivyleaf]

I don't want my users to have to figure out what fiscal year we are in for our database. I need to store the Fiscal Year in the table as it is part of our project number. Our fiscal year starts in July. July 1, 2000 was actually FY 2001, the same is true for January 25, 2001. Today is still part of FY2001. In other words 6 months before January 1, X and 6 months after January 1, X is the fiscal year.

Turn around is so great, and many people don't understand Fiscal Years which is why I just want Access to figure out what Fiscal Year we are in . Any suggestions for setting this up?

 

[MichaelRed]

Some (several) caveats. Something 'like' the below might help.

Dim FysYr as Integer

FysYr = Year(DateAdd("M", -6, MyDate))

Where MyDate is the current or target date for determiniation of hte Fiscal Year



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over