date in query to feed a form

  • Thread starter Thread starter lilbit27
  • Start date Start date
L

lilbit27

have a query and one of my fields is a date.

in the criteria i put <=DateAdd("m",-2,[rptdt]) so that it will
automatically give me everything that is 60 days past. my problem is
february stops on the 28th so it didn't pull 12/29-12/31 dates when
pulling everything 60 days past feb 28.

Does anyone know how to fix this?
 
If you want 60 days, then you should use this:
<=DateAdd("d",-60,[rptdt])
which will return 12/30/2005
Using "m" subtracts 2 months and returns the same day of the month. so you get
12/28/2005
 
Back
Top