Fiscal Year Query

  • Thread starter Thread starter Mark Matzke
  • Start date Start date
M

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
 
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)
 
Back
Top