Datetime formatting

[vk01]

Hi,

 

The report displays as "2007-10-01" which i need it to show as "10/01/2007" - currently this is a variable with the following syntax - it was showing the time as well which was not required. It is set up as variable with datatype string: original date is -

"2007-10-01 00:00:00"

--

$P{END_DATE}.substring(0, $P{END_DATE}.indexOf(" "))

--

 

thanks.

[Pedja]

Can you set the field to java.util.Date? Then set the Text Field Expression to new Date($P{END_DATE}), and Pattern to "dd/MM/yyyy". Or you can experiment with SimpleDateFormat class.

[Pedja]

This should work:

 

set the field to java.util.Date, Pattern to "dd/MM/yyyy", and Text Field Expression to (new SimpleDateFormat("yyyy-dd-MM")).parse($P{END_DATE})

[vk01]

I cannot set the parameter as java.util.date - it has to be a string. And this is not working if the parameter is a string. Any other way to format a string to a date.

[Pedja]

Leave the parameter as String, and set the TEXT FIELD to java.util.Date.

[vk01]

It comes back with error message - Cannot cast from string to date.

[vk01]

Solved! It is also posted in another thread.

 

Set the text field to java.util.date - and then use following -- (new SimpleDateFormat("yyyy-MM-dd")).parse($P{START_DATE})