Query using Date()

[Hfnet]

I am upsizing an mdb and I need to convert some queries>

I am querying using the following code:

SELECT DISTINCT itemsmain.tekref
FROM itemsmain
WHERE (((itemsmain.tekref) In (SELECT tekref FROM itemsmain WHERE datein Between Date()-90 And Date() GROUP BY tekref HAVING Count(*)>2)) AND ((itemsmain.datein) Between Date()-990 And Date()))
ORDER BY itemsmain.tekref;

And it is failing in the adp on the Date() bits saying 'Date' is not a recognized function name.

Can someone point me to the correct coding please?

 

[cmmrfrds]

If this is SQL Server Transact SQL then the current date function is getdate()

 

[Hfnet]

Not too sure. This is a stored procedure linking to SQL server 2003

I'll try the getdate and see how I go, thanks