2005 IR Help Posted September 2, 2006 Share Posted September 2, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now