Help with Date Expression in Query

T

TSG

I have a DB with a table that has InsertDate as one of the fields.
would like my query to show every record in the DB with an InsertDat
equal to today's date one year ago and earlier. I'm actaully trackin
the number records entered into the DB this year versus last year an
will run a report to show whether or not the records are increasing o
decreasing to date. Any help will be greatly appreciated.

Thanks
 
D

Duane Hookom

Take a look at using DateAdd(). From your description, the criteria under
the InsertDate field would be:
<=DateAdd("yyyy",-1, Date())
 
Top