SQL Syntax to Return records with only the Current Date

[AshleyRickards]

I am generating reports where I wish only to retrieve records where the date is the current date. My field is 'datetime' format.

TIA for any help. Ashley L Rickards
SQL DBA

 

[THoey]

Put a WHERE clause like the following:

WHERE MyDate = Date() Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[AshleyRickards]

I'm getting an error 'Date' is not a recognized function name.
Any idea's? Thanks. Ashley L Rickards
SQL DBA

 

[JoeMiller]

Please post your SQL statement, open your form in design view, click View-->SQL View. Maybe then we can help.

Another thing to check is that your references are correct. Go into any code window, click Tools-->References. If you see MISSING: <Description>, replace the file that is missing. This is a common error in Access, basically Access misplaces the libraries it needs to perform functions.

HTH Joe Miller
joe.miller@flotech.net