SQL Date Problem

[Guest_imported]

I'm having problems making a query that will show records younger than the day the query is made. For example: I want to be able get a querry of all records that have an "Inspection Date" overdue. This is what I have so far:

SELECT [ID], [NUM], [EQUIPO], [TIPO], [MARCA], [CAP], [MODELO], [SERIE], [DIVISION], [UBICACION], [SECTOR], [ULT INSP], [P PESO], [PROX INSP], [ST], [LINK], [COMENTARIO]
FROM [HOJA INFORME]
WHERE [PROX INSP] < ;

 

[Philly44]

WHERE [PROX INSP] < NOW; This should work, it will look for anything that has been entered before RIGHT NOW, if thats too precise then use DATE. You may have to put () at the end of NOW and DATE.

 

[jjonesal]

SELECT [ID], [NUM], [EQUIPO], [TIPO], [MARCA], [CAP], [MODELO], [SERIE], [DIVISION], [UBICACION], [SECTOR], [ULT INSP], [P PESO], [PROX INSP], [ST], [LINK], [COMENTARIO]
FROM [HOJA INFORME]
WHERE [PROX INSP] < Date();
J. Jones
jjones@cybrtyme.com