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