I'm trying to retrieve records with an AddDt that are 7 days or older from today. I think that the error lies in the DateAdd part of the statement. I'm not sure how to properly write this. Thanks.
Code:
Set sst = CurrentDb.OpenRecordset("SELECT * " & _
"FROM tblTask" & _
"WHERE tblTask.AddDt <= #(DateAdd('d',-7,Date()))# ")