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?