Convert String yyyy-mm-dd to month name

[maycarb]

I have a string file FECHA EMISION="2018-03-02". To show like "Marzo" I have to convert

$F{FECHA EMISION}.substring(5,7) 

in integer. But I don´t know how convert the result 02 to the month related

 

[mtn]

Hi,

You can do this using a date format. Possible date formats can be found here (for example): https://community.jaspersoft.com/wiki/date-and-time-patterns A pattern can be added to a textfield in the properties of a textield (in the properties find pattern).

Another reference on the use of date patterns can be found here: http://jasperguide.blogspot.com/2014/03/date-and-time-pattern.html

Hope this helps.

Kind regards,

Maarten

 

[hozawa]

Try the following.

(new SimpleDateFormat("MMMMM", (new Locale("es")))).format((new SimpleDateFormat("yyyy-MM-dd")).parse("2018-03-02"))

[maycarb]

Thanks.

I try this and works correctly

UPPER(DATEFORMAT(new SimpleDateFormat("yyyy-MM-dd").parse($F{FECHA EMISION}), "MMMMM"))

It shows me MARZO