keak182 Posted May 2, 2008 Share Posted May 2, 2008 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 ! :) Link to comment Share on other sites More sharing options...
jys Posted May 2, 2008 Share Posted May 2, 2008 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' Link to comment Share on other sites More sharing options...
keak182 Posted May 3, 2008 Author Share Posted May 3, 2008 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 ! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now