I have the following query which works fine:
Code: Select all
, Families.[Fathers name], Families.[Mothers name], Families.[Change date], Families.[Changed] FROM Families WHERE ( Families.[Change date] < JDATE('1 jan 2003') ) Order by Families.[Change date] I would like to change the query so I don't have to change the date. Ideally I would like it to be say ten years ago. I tried using Dateadd(years,-10,curdate()) and other 'googled' variations without success. Is this possible?