Hi BIll
Tried that

oCommX.Parameters.Add(new OleDbParameter("@MyDate", dtX));

Same result I'm afraid (no value given for one or more required parameters)
regards,
Gerard



>Gerard
>Try changing this:
>oCommX.Parameters.Add(new OleDbParameter("?MyDate ", dtX));
>
>to
>
>this:
>oCommX.Parameters.Add(new OleDbParameter("@MyDate ", dtX));
>
>Confusing, but when you add it you use "@" and when you use it, you use "?"
>
>
>
>>

>>Hi Bill. My code is below:
>>
>> OleDbCommand oCommX = new OleDbCommand();
>> string oConnX = @"Provider=VFPOLEDB.1; Data Source=" + @"C:\DISA\DIS2012";
>> string oSelX = "Select AAP_TITLE from DFAAP WHERE AAP_DATEBR >= ? ";
>> DateTime dtX = DateTime.Now;
>> oCommX.Parameters.Add(new OleDbParameter("?MyDate ", dtX));
>>OleDbDataAdapter oDaX = new OleDbDataAdapter(oSelX, oConnX);
>>DataSet oDsX = new DataSet();
>>oDaX.Fill(oDsX);
>>
>>If I Change the where clause to 1=1, rows are selected fine
>>The AAP_DATEBR is a Date Field in a DBF thats part of a .DBC
>>

>>
>>
>>
>>
>>>>

>>>>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));
>>>>>

>>>>>
>>>>>?
>>>
>>>Gerard
>>>
>>>It might help to show all your code, including the code executing the command