Problem with date format (yyyymmdd) and parameter

[agavus]

Hi ,

I've been working with IReport for two weeks now and I am having trouble creating a parameter input for my second report.

The dates are not stored in the database as datesformat but as YYYYMMDD and the field class for this field is Big.Decimal. I am trying to find a way the create a parameter with class java.util.date  were the user can enter a start end end date.

Is there an expression to convert the dates that are entered in the parameter to the YYYYMMDD values that are recognized by the SQL.

I used the text field expression

"new SimpleDateFormat("yyyyMMdd").parse($F{DATE_FIELD}.toString())"

to display the YYYYMMDD value from the database as an actual date in the report. What I am looking for is the other way around.

Or is there maybe a simpeler solution.

Thanks for the help.

 

 

Post Edited by Ronald Migo at 01/08/09 12:04

Post Edited by Ronald Migo at 01/08/09 12:04

Post Edited by Ronald Migo at 01/09/09 08:59

[hingerl]

hi,
 

$P{parameter1} = java.util.date;
USE_AS_A_PROMPT=yes
 

$P{parameter2} = java.lang.Integer;
DEFAULT_VALUE_EXPRESSION=new Integer(new SimpleDateFormat("yyyyMMdd").format($P{parameter1}))
USE_AS_A_PROMPT=no



in your SQL-Statment, you can use $P{parameter2}, maybe $P!{parameter2}

Post Edited by hingerl at 01/08/09 12:36

[agavus]

Superrrrrrrr.

This work great

Thanks a million.

Just one more question. For another report I want to display the records from the last two weeks. Is it possible to use something like  new date()-14 as a default expression?

Thanks

 

Post Edited by Ronald Migo at 01/08/09 15:59