>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)
If it's not broken, fix it until it is.
My Blog