help with date format for a SQl statment

[samos1023]

strSQL = "UPDATE Inventory SET TransDate = " & Date & " WHERE ID = " & ItemNum(i)



When I put the date keyword in my statement I get the current time stored into my field. i want the date instead.

here is what I get 12:00:59 AM
here is what i want 11/6/2017

[aytee111]

strSQL = "UPDATE Inventory SET TransDate = Date() WHERE ID = " & ItemNum(I)

[samos1023]

I cant do that in VBA, every time I add the () and move away from the line it goes away

[samos1023]

nevermind i got it, thanks

[aytee111]

It is a string surrounded by quotes, you can put anything inside a string.