I'm still having trouble. I have a DateTime stored as a string in a list.
I want to insert it into a DATETIME column:

CLEAR
CLOSE DATABASES all
USE TestData

sDateTime = .lstInfo.List(.lstInfo.ListIndex, 4)

sCommand = "INSERT INTO TestData (Caption, DateTime1) VALUES ('dd', sDateTime)"
&sCommand

RETURN

I get a Data Type Mismatch



>>Thanks
>>
>>
>
>You are welcome, but... I Forgot to mention that CTOT might create ambiguous dates so the recommendation is to use DateTime(nYear, nMonth, nDay, nHour, nMinutes, nSeconds)