Datestring offset

[hahagal]

Hi,

In ireport can we offset a datestring of one month? Currently I am doing it this way. I have converted the datestring to a date. How can I add one month to this date?

[mfirkser]

 The Java code below might help you out.

Code:

new GregorianCalendar().setTime(yourDate).add(Calendar.MONTH, 1)

[mdahlman]

Dates are hard to work with in Java. In general my recommendation is to use the Java Commons Lang library. It makes date manipulation much easier. I wrote an article about dates in JR and JRS in the past.

Good luck,
Matt

[hahagal]

In the report, I am using groovy language. Is it possible to add one month to a parameter datestring? I would like the output to be a date format.

[mdahlman]

I'll expand my earlier post.

Dates are hard to work with in Java. Dates are hard to work with in Groovy too! (I'm not aware of any Groovy features to handle any date functions like this.) My recommendation to use Java Commons Lang still applies. The samples that I include there use Groovy as the report language. They show exactly the type of calculation you are describing.

Regards,
Matt

 

[hahagal]

Hi,

Where can I find commons-lang jar for the DateUtils? I can't seems to find it in the ext directory of ireport. FYI, I'm using ireport 3.7.1.

[hahagal]

Hi,

The example in the link seems to be in Java language. Is there one for groovy? I'm still stuck on this.

[mdahlman]

The example in the report in the linked article is this:

DateUtils.addMonths($P{MyDate},-1)

Why would you care if this is Java or Groovy as long as it adds one month to your date? The article also links to the Commons Lang project. Just click "Download" to get to the downloads page.

Regards,
Matt

[pjamack]

 The example report/file on that page is corrupt and doesn't open...

 

Nevermind got it to open with Notepad.

Post Edited by pjamack at 08/04/2011 22:57

[pjamack]

 I got the textfield expression to work, add days, subtract days etc.  

What I'm having issues with is passing a parameter using this expression. Say $P{StartDate}-7 days.  Always comes back with errors regardless of what I do.  The other issue seems to be textfields works but variables and parameters don't work the same way.... 

If I want to set up July 1 - July 7 as

Week                      MON     TUES   WEDS    THURS   FRI

WeekONE                27          33         44           55          66

WeekTWO                8             5           5              6             7

WeekTHREE           4              44       66             22          11

WeekFOUR             4              11        1               2             2

 

TOTAL                    43              93          

 

You get the point.    All I get back from the function is a Date, count#, etc.   From that point I need to convert StartDate and EndDate into Weeks, convert Date into Day of Week,  and then populate the Days of the week numbers in the appropriate column and appropriate Week.

Then Total those days up at the bottom.     

So far converting, calculating, and counting all this stuff in Jasper is one big pain. And doesn't exactly work.

Post Edited by pjamack at 08/04/2011 23:08

[hahagal]

Hi Matt,

Thanks! It works for me now. (: