Year Date Change?

[aellistechsupport]

I am currently using Year(Date()-1) and Year(Date()) for current year to prior year comparison.



However when the new year came the Dec. comparison is lost due to the Year(Date()-1) and Year(Date()).

I'm not sure how to change it so that Jan of the current is still looking at the prior year from last year and prior year as the Year(Date()-1) and Year(Date()).

Hope this made sense.

[June7]

Could have an expression: Year(Date()) - IIf(Month(Date()) = 1, 1, 0)

Really, best way to handle is to have parameter input. This can be a popup from query (I never do popups) or reference to a control on form.

[Rawb]

You also have to think about Feb. 29th. That date wouldn't work in your query either, since there will never be a Feb. 29th for the previous year.

Probably the best way would be to simply compare the current date with the date 365 days ago instead of 1 year ago.

DateAdd("d", -365, Date()) ' Use days instead of years to prevent dates around the beginning/end of each month from behaving strangely

[June7]

I just noticed the expression in OP is subtracting 1 day from the date. That won't return previous year. Did you mean: Year(Date())-1 and Year(Date())