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

Discussion in 'ASP.NET / ASP.NET Core' started by CCprogrammer, Nov 6, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. CCprogrammer

    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
     
    CCprogrammer, Nov 6, 2004
    #1
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page