How to get and check dates in Access

[spearssc]

HI,
I have the need to do a bulk delete where I have to check records in an Access DB against the current date. If the record is one year or older based on the current date it is deleted. The date is currently stored as 10-Jul-05. I want to call a SQL statement to do the date check and delete based on the date the user enters in a textbox. I'm using Access 2000. I know I need to get the current date but I don't know how in Access. I know Acess uses VBA but i 'm not sure how to incorporate SQL that way.

Thanks in advance for your assistance with this matter.

Each One Teach One for the advancement of the "CRAFT"!

 

[PHV]

To get the current date simply use the Date() function either in SQL or VBA.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886