Query for date

[naseto981]

Hello every one,



I have a field with dates when some products go out of date, and I have to make a query which checks if this products are out of date or no.I will be glad if someone help.

[orange]

This will show which Products have passed the BesttBeforeDate.

SELECT ProductName
, BestBeforeDate
FROM tblProducts
WHERE
BestBeforeDate - Date < 0;

[naseto981]

I don't understand, it should be somethink like this ?