Date Expressions


hopefully someone can help with this problem as I'm losing the will to live! ;)

We have eventually managed to get reports working through Java Servlets and I have just started to build our first proper report.

Part of the report requires me to test if a date is < 3 months from the supplied report parameter date and if it is then make the field blank. Also the expression needs to handle null dates. How on earth do I do this?

I'm not to worried about calculating the difference on the fly as I could easily pass this into the report from my PHP page. I need the expression syntax for something like this:-

(($FieldDate != null) AND ($FieldDate after $3MonthDate)) ? $FieldDate : ""

We are not Java experts so please do not be offended if this is a stupid question. Is it possible to create a class that could manipulate/test dates and call this at runtime using the expression builder?

Thank you in advance.
Webby's picture
Joined: Jul 19 2006 - 10:13pm
Last seen: 17 years 2 months ago

0 Answers:

No answers yet