Hi, Gerard,

If you want to construct your SQL syntax in your application layer, the syntax would be...

string lcSelect = lcSelect = "DOC_DATE BETWEEN '" +  ldFrom.ToString() + "' AND '" + ldTo.ToString() + "'"; 

However, I don't advise this - you're better off building a stored procedure that accepts the 2 dates as parameters (the "@" symbol that you were using is for SQL parameters inside SQL server).

Kevin