Actually, since Date() is an Access function, it really should be taken OUTSIDE the quotes, that is...
SQLstr = "SELECT * FROM tblJob WHERE [n] < #" & Date() & "#"
where n is a field in the table. Note: If Date is a field you made up, then change its name. Date() is an Access function, and having a field with the same name will cause problems.
Michigan Dept. of Environmental Quality, Air Quality Division