Convert date parameter to simplified format using iReport

Question

I have startDatealso endDateas input parameters. These parameters are used in the request:

SELECT * FROM patientRecords 
WHERE patientRecords.dateOfdischarge BETWEEN $P{startDate} AND $P{endDate} 

Now, since startDateand endDateare the parameters that are passed to JasperReports.

I have to make sure they are in mm/dd/yyyyDate format .

How can I convert an input parameter to this format with iReport?

Answer 1

U can try changing patern from propertise> textfield propertise or you can try this to_char (table_name.name, 'mm / dd / yyyy') as the field name

Answer 2

, , Mysql

date_column_name date_format ($ P {start_date}, '% Y-% m-% d') date_format ($ P {end_date}, '% Y-% m-% d') date_column_name date_format ($ P {start_date}, '% Y-% m-% d') date_format ($ P {end_date}, '% Y-% m-% d')

Answer 3

If I were you, I would directly send these parameters in the same way as in the format you specified in Java. If this is not possible for you and you want to be sure, you can use EL to format, for example, Java or Groovy in iReport