obtain data for 12 months rolling

  • Thread starter Thread starter Karine
  • Start date Start date
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
 
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()
 
Back
Top