Compare Date in Acess to Current Date in ASP

P

Peto

How do I compare a date field in a table in access to the current date
using ASP. I wish to check that the date is no more than 6 months
old.

I wish to do this when I open the recordset using SQL...for example

strSQL = "SELECT * FROM tblCarInfo WHERE Date ???????"

the ?????? needs to only select the records than have been entered
within the last 6 months.
 
Top