i am working on a application in that i need to get the closing balance of stock item based on date and item the problem is the query gives the final closing balance of stock item but i want closing balance on particular date here is my query OdbcConnection odbc = new OdbcConnection("DSN=TallyODBC_9000"); OdbcCommand cmd = new ODbcCommand("select $Name,$ClosingBalance from Stockitem where $Name = itemname",odbc); this result gives the closing balance on current date how to get closing balance on particular date? how to use date in odbc command ? any information will be helpfull thanks in advance.