Query Help

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

Guest

Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...
 
Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...
Click to expand...

Between Date() and DateAdd("m",-13,Date())

will return records between 4/26/2006 and 3/26/2005

Is that what you want?
 
Back
Top