>I am trying to have a WHERE clause on a SQL Passthrough query from SQL 2000 to VFP 7 that filters on a date but it does not seem to evaluate correctly. I get all records back regardless of the date. Here is the code:
>
>
>DECLARE @SQL AS varchar(500)
>SET @SQL = 'SELECT * FROM
> OPENQUERY(VFP_BID,
> ''SELECT d.bid_no
> ,d.bid_dash
> ,d.status
> ,d.item
> ,d.cust_po
> ,d.award_date
> FROM bid_det d
> WHERE d.award_date > {^2006-11-31}
> ORDER BY d.bid_no, d.bid_dash''
> ) Rowset_1'
>
>--SELECT @SQL
>EXEC (@SQL)
>>
>Any ideas?
I think you have a typo in date. You might prevent the typo using:
>= {^2006/12/1}Update: Dismiss. I see that you already found the typo.
Cetin
