Comparing a Date to Date with Integer Offset

[ktrinad]

By: Amanda Gellhouse - agellhouse

Comparing a Date to Date with Integer Offset

2003-04-03 18:36

I need to use the following formula to determine whether a graphic is printed or not:

date1 < date2 - dayOffset

 

Where date1 is a Date field in the report, date2 is a Date parameter, and dayOffset is the number of days as an Integer parameter.

 

I have tried a number of variations in the Print When Expression field, but can't find one that works. Does anyone have any suggestions? Or perhaps a custom class with this functionality?

 

Thank you!

 

 

 

 

By: Giulio Toffoli - gt78

RE: Comparing a Date to Date with Integer Offset

2003-04-04 02:36

First af all, in the printWhenExpression you must put something like this:

 

new Boolean( EXP )

 

now, if you date fields are of type java.sql.Date, you can write something like this

 

new Boolean( $F{myDate1}.after($F{myDate2}) )

 

if your date as Long, you can do...

 

new Boolean( $F{myDate1}.longValue() < $F{myDate2}.longValue() )

 

I hope this helps you

 

Giulio

 

 

 

 

By: Amanda Gellhouse - agellhouse

RE: Comparing a Date to Date with Integer Offset

2003-04-09 18:36

Thanks for the help!