Query Rolling 12

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please help me with an expression to query rolling 12 (full)
months?
Like Jan05 back through Jan 04, and then when Feb is complete, roll off
January??
Thanks for your help.
 
daknight said:
Can someone please help me with an expression to query rolling 12 (full)
months?
Like Jan05 back through Jan 04, and then when Feb is complete, roll off
January??
Click to expand...


Use the DateDiff function in a calculated field:

Expr1: DateDiff("m", datefield, Date())

with a criteria of <=12
 
Back
Top