The date time field in .NET will properly map to a date field in the database - it'll strip off the extra timestamp data and just leave the date.
If I recall VFP OleDb syntax you can't name parameters in queries - just use a ? and positional parameters (ie. 1st ? is the first parameter).
Hope this helps,
+++ Rick ---
>I need to acccess VFP data from C# code. the table I am accessing has a date field. But C# has DateTime only. How do I go about this?
>Here is a query:
>
>
>SELECT dinvoice, nftotpaid + nftotdisc + nftotadj + nftotdebt + nfbalance AS Amt
>WHERE dinvoice BETWEEN ? StartDate AND ? EndDate
>FROM arinvc
>
>
>BTW, ? mark is not taken either.
>
>What is the correct syntax?
>
>Thanks