It is not going to work though because lets say the date is 1/8/2001 and that should be in the fiscal year 2000. So adding to the date does not work. But whenver I try to subtract then it says that "You tried to execute a query that does not include the specified expersion 'Year(DateAdd("m",-6,[Seminar].[Date])' as part of an aggregate function.
Alright sorry I fixed the above post now it is correctly asking my question. Also when I put anything else except Year(DateAdd("m",6,[Seminar].[Date]) it says the same thing. For example I cannot put