retrive the sum of qty from a database file where the date less than 31/12/2003

[CCprogrammer]

Hello Gentelman,

I want to retrive the sum of qty from a database file where the date less than 31/12/2003

i wrote it like that:




Dim PREVDATE2 As New Date()


PREVDATE2 = CDate("12/31/2003")



Dim DACC As New OleDbDataAdapter("Select sum(TRANSQTY) from trans where Val(transdate) < " + "'" + PREVDATE2 + "' And Doc =" + "'" + MyDoc + "' AND shipping = " + "TRUE AND SHPCNT = " + "'" + MyCountryCode + "'", Trans)





thanks in advance





Best Regards





Mohamed