I am trying to delete records from a table that are older than one year from the current date. Here is my query:
DELETE tblDataLogger.ID, tblDataLogger.Unit1, tblDataLogger.Unit2, tblDataLogger.Month, tblDataLogger.Day, tblDataLogger.Year, tblDataLogger.Hour, tblDataLogger.Minute, [month] & "/" & [day] & "/" & [year] AS Datestamp
WHERE ((([month] & "/" & [day] & "/" & [year])<=Date()-365));
However this does not find the records older than one year. Can someone please help.