>Hi everybody
>I have created a VFP9 view to get data from MS-SQL Server 2005. I want to filter records for a datetime filed. I have written datetime value like {^2011-01-01 00:00:00} but it does not accept. Any idea please. I do not want to use local view after it to make filter.
>
>Regards,
Try
'20110101' -- since you don't use time portion, you can pass just date.
If it's not broken, fix it until it is.
My Blog