Hi everyone:

I am trying to write a "simple" select statement.

I want to only pull data from that is less than or equal to the current date from a specific table and field.

Something like this:

SELECT * From Jobs
WHERE JobCloseDate <= ?

the problem is I don't know what to write to indicate "currentdate".

Does anyone know the correct syntax/word to type?

TIA

jason