Where Clause

[cpampas]

Hello

Set rstNotDatas = db.OpenRecordset("SELECT * FROM tblDatasRec " & _
"WHERE DataRec=" & (Date))

I am trying to create a recordset in wich the field DataREc (data type) is equal to the present day. It returs zero records, but I hace 15 records in my table with todays date
Something to do with formatting the date ? my format is 09/05/2014

Thanks

 

[pr2-eugin]

Try,

Set rstNotDatas = db.OpenRecordset("SELECT * FROM tblDatasRec " & _
                                   "WHERE DataRec = " & Format(Date, "\#mm\/dd\/yyyy\#"))

 

[cpampas]

Paul,
Thanks a lot for your help, it works fine
Carlos