Quote Originally Posted by xboner
I checked it in phpmyadmin, it shows 0000-00-00.
That suggests he's using MySQL. I don't recall off the top of my head how MySQL handles date delimiters, but I think using single quotes around it should be sufficient.

Quote Originally Posted by SamOscarBrown
(However, "I" prefer not to use the parameter queries...as I (OFTEN) make mistakes when coding, I like to see (in Immediate Window during Debug), what I actually sent to the database...the "?" usage does not allow me to see the actual values passed (in the statement, that is),,,just easier for "ME" to write out the placeholders in the query so I can check it even before executing it.---I make a lot of mistakes!
I'm the the other way around. I find I make more mistakes when dealing with stringing text along in a SQL statement. For me, parameterized queries are easier to read, and I don't have to worry about getting the right number of paired off quote marks correct. But yeah, I hear ya, sometimes it's hard to "see" the values being passed in through the parameters. It probably affects me less since I'm usually working in SQL Server, so I have SSMS where I run everything, and I'm usually running stored procs (usually, not always)... so I can easily, pause, get the parameter values, then set up a SQL script to mimic the call from VB to see what's what.

If I was working in Access, my attitude would probably be different.

-tg