Here is my code:
SQL = "SELECT SUM (Credits)[AmtPaid] from Table1 where date > dateadd(day,-385,getdate()) and customerid = '200'" if AmtPaid > 100 then response.Write "greater than 100" else response.Write "Amt is less than 100" end if
This is the table view of the code:
It should say “greater than100”. not less than 100.
So can anybody tell me where I am going wrong?