obtain data for 12 months rolling

K

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
 
A

Arvin Meyer [MVP]

Karine said:
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
Click to expand...



How about:

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