type conversion problem in transformer

[bobbysridhar]

Hi,
I am trying to compare current timestamp with effective date(which is timestamp) in the if statement in transformer stage. when i try to compile the job it is giving the following error:

'Invalid conversion requested from a timestamp to a int64.'

Could somebody help me in fixing this

[chulett]

Show us what you are doing, the syntax you are using and the data types involved.

[bobbysridhar]

IF(DSLink326.POLICYSTATUSCD='cancelled') then (if(abc< DSLink326.EFFECTIVE) THEN 'inForcePending' ELSE IF(abc>= DSLink326.EFFECTIVE) THEN 'inForce' ELSE '') ELSE IF(DSLink326.POLICYSTATUSCD='issued') THEN (IF(DSLink326.CANCELNOTICEIND=1) THEN 'cancelPending' ELSE IF((DSLink326.CANCELNOTICEIND<>1) AND (abc>= DSLink326.EXPIRATION)) THEN 'expired' ELSE IF((DSLink326.CANCELNOTICEIND<>1) AND (DSLink326.EFFECTIVE<= abc<= DSLink326.EXPIRATION)) THEN 'inForce' ELSE IF((DSLink326.CANCELNOTICEIND<>1) AND (abc> DSLink326.EFFECTIVE)) THEN 'inForcePending' ELSE 'issued') ELSE IF(DSLink326.POLICYSTATUSCD='bound') THEN 'bound' ELSE IF(DSLink326.POLICYSTATUSCD='companyDeclined') THEN 'companyDeclined' ELSE IF(DSLink326.POLICYSTATUSCD='customerDeclined') THEN 'customerDeclined' ELSE IF(DSLink326.POLICYSTATUSCD='dataGather') THEN 'dataGather' ELSE IF(DSLink326.POLICYSTATUSCD='proposed' )THEN 'proposed' ELSE IF(DSLink326.POLICYSTATUSCD='rated') THEN 'rated' ELSE ''

[qt_ky]

Make sure the abc data type is also timestamp.