Fiscal Year Query

[Mark Matzke]

I need to run a query for yearly numbers, for example, include all dates from
December 22, 2007 through December 21, 2008 (Year needss to be reletive to
the date , that would be a full date such as 03/03/06). I had created a
fiscal month query that has worked great:


DateSerial(IIf(Day()<21,Year(DateAdd("m",-1,)),Year()),IIf(Day()<21,Month(DateAdd("m",-1,)),Month()),22)
And
DateSerial(IIf(Day()>=21,Year(DateAdd("m",1,)),Year()),IIf(Day()>=21,Month(DateAdd("m",1,)),Month()),21)

Thank you,
Mark Matzke

 

[Allen Browne]

So if the date falls in the last 10 days of the year, you want to treat it
as if it were in the following year?

Try typing an expression like this in the Field row in query design:
TheYear: Year( + 10)