Date comparision

Hi,
I neet to compare date fileds in sql and webmethods
the date field of SQL.
date field , say Transaction_Date is string and contains value 01/08/2006.
date field, say TranDate is java.util.Date(metioned in selectAdapter service), has value 02/08/2006.
now i need to compare these values
branch step
—sequence step(%Product/Transaction_Date% = %results/TranDate)
-----debuglog(message-‘cannot store’)
but in my case, since both the dates have different values debug log should not be executed, but for me now the debug log is executing, even both the dates are not equal!!!
what is the problem?

Hai chowdary!

did u make branch step propertity Evaluates labels ‘true’ ,if not make it and try.

if u do the Evaluates labels true already…

in the use == for comparision of two datattypes instead of ‘=’
—sequence step(%Product/Transaction_Date% == %results/TranDate)

inthe condition (%Product/Transaction_Date% == %results/TranDate) i think u are forget to give % at end for results/TranDate please keep % if forgot

anilellendula

Hi,
I did not forget giving % at last.
however i will try with ur option

Hi Chowdari,
The result in the JDBCAdapterService is a docList and so use the Loop step before you use the branch step. If you are sure that you will always get only 1 record in your SQL output, then you can avoid the LOOP but you still need to use in your label(%Product/Transaction_Date% == %results[0]/TranDate%)

HTH,
Bhawesh.