VBA Date-Field keeps displaying 12/30/1988

[jjones100]

Having a problem with this code:
Mydate = VBA.Date
SQLUpdate = "UPDATE CustomerImports SET SentToBeKeyed =" & Mydate

Looks simply, but after I run this code the database table has the value of 12/30/1988 and then when i actual click inside the cell in the table it shows 12:00:07 AM. I have tried changing data to text and date & time but still will not hold correct current date. I know the mydate variable is correct. What is up with this? Thanks

 

[PHV]

Either:
SQLUpdate = "UPDATE CustomerImports SET SentToBeKeyed=#" & Mydate & "#"
or:
SQLUpdate = "UPDATE CustomerImports SET SentToBeKeyed=Date()"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jjones100]

Oh, Thank you so much!! That did the trick.