>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

Put FROM clause before WHERE. If the above will not work, try
where dInvoice between CAST(?StartDate as Date) and CAST(?EndDate as Date)