If Statement in Expression Editor

[richard_13]

Hi there

I am trying to create a field that tests for a date being between two dates and then if it is I want to display that date but if not I want to display a blank field or null.

I have used the expression editor and created the following:

IF(AND($F{Hiring_Date} >= $P{ReportStart}, $F{Hiring_Date} <= $P{ReportEnd}), $F{Hiring_Date}, "")

The expression editor sees it as a valid expression but when I try to preview my report I get an error message saying:

The operator >= is undefined for the argument type(s) Timestamp, Date

What am I doing wrong ?

Thanks

Rich

 

[richard_13]

I have now changed the class of the Paramaters to java.sql.Timestamp so that all three items are the same class.

The message has now changed to:

The operator >= is undefined for the argument type(s) java.sql.Timestamp, java.sql.Timestamp

[richard_13]

I seem to have sorted this using .after and .before