current date

Question

Hi to all,

I have an error using  the current date default value lov, in my jasper report.

error while attempt to load filters Illegal format for Value List Date Type [08/11/2017], unable to find symbol [#]

 I Create my Lov with this query:

select DATE_FORMAT(curdate(),'%d/%m/%Y') valore, DATE_FORMAT(curdate(),'%d/%m/%Y') id from dual

Then I create a new analytical driver with type DATE, that use this lov as default value.

The problem is only in the default value, because if I don't set any default value the prompt work correctly.

Seems that the problem is the missing # symbol, anyone know if the date value has to be set in a particular format?

Thanks for reply

Alessandro

Answer 1

Hi!

You shoud specify date format like this "10.11.2017#dd.MM.yyyy"

Comments

It works!!!

Thanks