Skip to Content
Former Member
Oct 22, 2007 at 06:57 AM

Current Fiscal Year Question


Hallo out there, here my problem:

The actual month ist october and so the actual fiscal year of my company is 2008. In my query i want to show the "year to date" and the "date to year end" result of a fiscal year. i check this based on "current fiscal year". my problem now is that in october there is a switch in the fiscal year from 2007 to 2008, but i want to show the results of 2007. so i need a query which automtically makes "current fiscal year-1" in october, but in the other months stays normal on "current fiscal year"

i hope i could describe the problem understandable

thx for your help

regards Rainer