Cannot Boolean to Integer

[rwnetwork]

Hi there,

Anyone know why this is error is occuring with my simple expression in my tmap?  I'm confused.  I have an integer input going to an integer output and it's bringing in an error about Boolean types?  I just want to return the date that is >= another date.  Please if anyone can help, I'm on a deadline.  Thank you Community!

[akumar2301 · Accepted solution]

Your expression returns a boolean ( >=) and then you joining it with an integer

You can try like ( syntax no correct)

(Minratedate >= miratedate) ? 1 : 0

[rwnetwork]

Thanks Abhishek!  Let me try this in my design.

It worked!  Thanks again.

[rwnetwork]

Hi again,

I realized that this didn't work 100%.  This is what I'm using in my tmap, however, values returns are 0's and they are supposed to have dates.

Thoughts?

Anyone? Please and thank you.

[akumar2301]

if you need date in integer format , you need to convert youe expressions output accordingly.

booleanExpression ? IfTrueExpression : IfFalseexpression

[rwnetwork]

Thanks, so are you saying that I still need to convert the whole Boolean expression to my needed data type, which is integer?

makethisInteger(booleanExpression) 

[akumar2301]

check ternary operator documentation , you will get more idea .
Try this :
https://www.geeksforgeeks.org/java-ternary-operator-with-examples/