Sql for date problem

[kabilliu]

[SOLVED] Sql for date problem

I have the following sql statement to update some records to a table by a form:

Set rs = cdb2.OpenRecordset("SELECT * FROM tblSpy WHERE ID=" & Me.cbxItems.Value & " And [SpyDate]=#" & Me.saleDate & "#", dbOpenDynaset)

I believe that he problem is on Date syntax. The format of my date field is short date (dd/mm/yyyy).
I appreciate any help
Thank you in advance

 

[kabilliu]

Re: Sql for date problem (SOLVED)

Ok I solved my code problem as following:

Set rs = cdb2.OpenRecordset("SELECT * FROM tblSpy WHERE ID=" & Me.cbxItems.Value & " And [SpyDate]=#" & Format(Me.saleDate, "yyyy-mm-dd") & "#", dbOpenDynaset)