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)
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people