Trouble with Dates

[anupam]

I want to create a parameter query,where the user will enter the date and the query will return records for the past 4 months from that date

Here is the SQL I have written but the results doesn't match

PARAMETERS ReportDate DateTime;
SELECT ExternalTicketsResolved.*, ExternalTicketsResolved.[Date Created], ExternalTicketsResolved.ID
FROM ExternalTicketsResolved
WHERE ((ExternalTicketsResolved.[Date Created])>([ReportDate]-4))
ORDER BY ExternalTicketsResolved.ID;

waiting for a quick response.

 

[KenHigg]

waiting for a quick response -

 

[inspectorgadjet]

I think what you might be looking for is the DateAdd function.
Your query would subtract 4 days from the [ReportDate]

Instead of [ReportDate]-4 try DateAdd("m",-4,[ReportDate])

I reckon that will give you what you need.