Jump to content
Changes to the Jaspersoft community edition download ×

date alteration


2005 IR Help

Recommended Posts

By: tyman26 - tyman26

date alteration

2005-08-26 09:17

I need to add days to a date parameter that gets passed into my report. I was wondering if anyone knew an easy way to do this other than writing a class. Is there something like this that I can put in the expression?

 

new Date($P{some_date} + 4)

 

 

 

 

By: harvestmoon1200 - harvestmoon1200

RE: date alteration

2005-11-08 23:08

try use

 

DATE_ADD($P{date_from}, interval 4 day)

 

in the query..

 

if want the date earlier, use DATE_SUB

 

if the increment is in month, use interval 4 month

in year, use interval 4 year

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...