java.sql.timestamp problem

[nkrowe]

This is my expression in the expression editor: $F{classes_class_begin_date} + " -- " + $F{classes_class_end_date}

Both classes_class_begin_date and classes_class_end_date are class java.sql.Timestamp

When I run the report, I get the error: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression.

Either field works ok alone but when I combine them (as above) I get the error. An I combining the wrong???

[AnnMary.Thomas]

If your data is coming from query can you modify your query like this

To_Char(start_date,'dd.MM.yyyy') || ' - ' START_DATE , To_CHAR(end_date,'dd.MM.yyyy') END_DATE

Here  "-" this is appended to the Start _DATE

 

[nkrowe]

I finally got it to work by adding some format to the expression.  Here is the result:

new java.text.SimpleDateFormat("EEE, d MMM yyyy, hh:mm aa").format($F{classes_class_begin_date}) + " -- " + new java.text.SimpleDateFormat("EEE, d MMM yyyy, hh:mm aa").format($F{classes_class_end_date})

[AnnMary.Thomas]

Can I know why this was voted down? This is a solution which is working and which Im using for one report.