Hi Borislav
=======================================================
string oSel = "Select Myfield1,MyDate from MYTable WHERE MyDate <= ? ";
DateTime dt = DateTime.Now;
oComm.Parameters.Add(new OleDbParameter("?MyDate ", dt));
=======================================================

Still get a message: No value given for one or more required parameters
Beginnig to think that maybe you cannot use parameters with OleDb and Foxpro and a Date Field and maybe I have to change 
 to stringing in everything (and I know..leave it open to Sql Injection etc )
What do you think ?
Have you yourself ever got OLEDB with a Date Parameter to work ?

Regards,
Gerard

>>Hi Borislav.
>>Yes I have seen Ricks link but nowhere do I see an example with a DATE in the parameter
>>Regards,
>>Gerard
>
>

>string oSel = "Select Myfield1,MyDate from MYTable WHERE MyDate <= ? ";
>DateTime dt = DateTime.Now;
>oComm.Parameters.Add(new OleDbParameter("?MyDate ", dt));
>

>
>?