I am trying to create a query that will return this month records (the records are under the field "enddate" and the format is date/time)
I have tried this but it is not working:
PARAMETERS [Enter Current month] DateTime;
SELECT Interns, Companies, "Position title", startdate, Enddate
FROM Table1
WHERE
MONTH(GETDATE([Enter current month]))=MONTH(GETDATE(enddate))
ORDER BY enddate;
AND IMPORTANT!!
I can not use "getdate ()" on ms access is there another way please??
what am I doing wrong?
Thanks for the help!!