Dateformat jaspersoft studio

[elenauscom.u]

Good afternoon. I'm having a problem with formatting the date. I use the json file adapter, which contains the property value "2018-01-01". This property is of type String. I start to enter the required format in the field pattern, but nothing happens, other classes also do not work. Can you please tell me what to do?

 

[narcism]

In the JSON file you have dates in String format. If you want to treat them as dates in your report, you need to:

1. declare the fields with the appropriate Date type(e.g. java.util.Date, java.sql.Date, etc.)
2. specify the Date pattern in the Data Adapter file/dialog for proper conversion from String to your type. Your pattern may be something like: yyyy-MM-dd
3. set the desired pattern at textField level

[lenapac15.29]

I did it, but I can not. I specified the correct data type, I specified a pattern. It turned out only after I specified: new SimpleDateFormat ("yyyy-MM-dd"). Parse ($ F {invoiceDocDate}) in the field expression.

I do not know why it's impossible to change the type to java.util.Date, writes the error that you can not get data from the json file.

Thanks for the answer.

[narcism]

Please post some sample JRXML and the Studio version in order to reproduce your issue.