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