>>>I found that another syntax works, {ts 'YYYY-MM-DD 00:00:00'}. Do you see anything wrong with this?
>>>
>>>>SQL Server does not understand VFP datetime literals
>>>>

>>>>TableName.FieldName >= '2010-04-01' and TableName.FieldName < '2010-05-02'
>>>>

>>>>>
>>
>>Yes, use parameters (did I tell you to use parameters before?). To see how to handle this correctly check:
>>Re: SQL Server DateTime in SQL Select Thread #1463837 Message #1463838
>>Cetin
>
>Cetin,
>I realize that using parameters is a better approach. However, I have to follow the design that uses a 3P tool that does not allow me to use parameters. So I have to find the best method given what I have. Thank you.

I don't understand. If you have a tool that doesn't allow to use parameters then do not use that tool but do use parameters.
Cetin