if ldQuote is a date, how can you compare that with Upper(), which is presumably character?

>I have an error message coming up that says that the Data Types are different yet when I check them, they are both Date data types. The comparisons are both between DATE Data Types. Why then the error?
>
>

>		CASE .cboOrder.ListIndex = 5	&& Quote Date (dQuote)
>			LOCAL ldQuote AS Date
>			ldQuote = CTOD(ALLTRIM(UPPER(.txtSearchBy.Value)))
>			SELECT ;
>					RECNO() AS Rec_No, ;
>					QuoteID, ;
>					CustPartNo, ;
>					Proj_Name, ;
>					Cust_Name, ;
>					dQuote, ;
>					Material1 ;
>				FROM Quotes ;
>				WHERE UPPER(dQuote) = ldQuote ;
>				INTO CURSOR tmpQuotes2
>			
>			SELECT tmpQuotes
>			ZAP IN tmpQuotes
>			APPEND FROM DBF("tmpQuotes2")
>			LOCATE
>		
>	ENDCASE
>	.grdFindQuote.Refresh()
>	.grdFindQuote.SetFocus()
>ENDWITH
>