>Ok, then how does it get appened to the insert string if it's a DateTime. It would need to
>be a string to add it to the string.
sCommand = "INSERT INTO TestData (Caption, DateTime1) VALUES ('dd', ctot(sDateTime))"
I think I am not understanding you correctly, your sCommand looks fine to me, you would need a transformation if you were doing something like
sCommand = "INSERT INTO TestData (Caption, DateTime1) VALUES ('dd', " + sDateTime + ")"
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges