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.



>You still need to transform sDateTime to a real datetime
>
>Depending on how you have it in the list, this might work or not
>
>sCommand = "INSERT INTO TestData (Caption, DateTime1) VALUES ('dd', ctot(sDateTime))"
>
>
>>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)