the date format in input controls

[keak182]

Hi there, I am using ireports to create date inputs in jasper server, but I can't seem to get the "date type details" correct and was wondering if anyone can help me.

 

If I would like to have my default pattern to be say 2008-10-31 ... what would I type in the pattern input box ?

I tried:

"yyyy-MM-dd"

yyyy-MM-dd

 

Also, I have tried to set the minimum value to

"2008-10-31"

2008-10-31

 

but that didn't work .... Am I entering the wrong values here for these input fields ?

 

I am using mysql and the date format is 2008-02-01 and I'll need to have the date picker input the same format in order to select date ranges form my mysql database.

 

 

Any help will be great appreciated ! :)

[jys]

if you want to use it in query

 

convert the date into sql date

 

querydate = new java.sql.Date(<date>)

 

ex.

select * from .. where fromdate>='querydate'

[keak182]

HI there jys,

 

thanks for the quick reply.

How would I tie this into the datepicker though ?

I am currently referencing the input control in my query like the following:

 

select * from ... where mydate > $P{from_date} and mydate $P{to_date}

 

or do I need to define that directly into the jsp ?

 

sorry if this may be an obvious question to some ...

 

thanks !