Variable expression (date field)

[edink79]

Dear all,

I have a datefield (field_2989) stored in database as unixtime. As I want to show that field in my report in dd-mm-yyyy format I use this query "select from_unixtime(field_2989, '%d-%m-%Y')". This works as expected, no problem at all.

I have defined a variable which pulls data from this field, but cannot figure how to write variable expression to format the result. All I am getting is unixtime integer, but not formatted date.

Anyone knows a solution to this?

Thanking in advance.

[jgust]

What is the classtype for this "from_unixtime(field_2989, '%d-%m-%Y')" field, and can you provide a screenshot of what is being returned?

[luked]

You could try adding this into a text field -

new SimpleDateFormat("dd-MM-yyyy HH:mm").format($V{Your Variable})