hello,
I tried to run this query without succeess:
SELECT Interns, Companies, startdate, Enddate
FROM Table1
WHERE Enddate=DateAdd("d",7,date(2009-7-31))
I want to retrieve the end dates of the interns before the end date actually reaches, that is 7 days before. I used this this query but i get an error message.
Is sth wrong with it? Please help!!