Problem with DataTable.Select() method

Question

Hi all!
I have a problem, the code below throws an exception:
Code:
DataRow[] Rows = dsDataSet.Tables["MyTable"].Select("NumericColumn = " + NumVar + " AND DateColumn = " + DateVar.ToString("dd/MM/yyy"));
Exception:
Cannot perform '=' operation on System.DateTime and System.Double
String value of the Select statement:
"NumericColumn = 1 AND DateColumn = 08/20/2004"
somebody knows why?
Thanx in advanced
Regards

Carlos Sanchez · Answer

I can't believe it!!
Really, I tried that before n' it didn't work, But I heve just tried it n' it works.
thank you charliezcc.
I Appreciate your help

axd33 · Answer

Carlos, try putting single quotes around 08/20/2004