Well I would repeat, don't build a string. Pass as a parameter. Why "has to be"?
Cetin
>Thank you, Cetin. Since I am creating a sting that has to be passed with Date value built-in, I changed my code to convert the Date variable to a string using DTOS().
>
>>No! This is the wrong way IMHO.
>>
>>
>>mDateVar = date(2008,6,1)
>>cSqlCommand = "select * from mytable where myDateTimeField >= ?m.mDateVar"
>>
>>Cetin
>>
>>