obtain data for 12 months rolling

[Karine]

I have a database to compile data on attendance & absenteeism.

I have over two years of data. Two ways to look at the absenteeism: monthly
basis and 12 months rolling (last 12 months).

I am looking for a formula that would give that 12 months rolling in my query.

Thanks a lot

 

[Arvin Meyer [MVP]]

I have a database to compile data on attendance & absenteeism.

I have over two years of data. Two ways to look at the absenteeism:
monthly
basis and 12 months rolling (last 12 months).

I am looking for a formula that would give that 12 months rolling in my
query.

Thanks a lot

How about:

Between DateAdd("m", Date(), -12) And Date()