keak182

Hi there, I am currently working in ireports and have a date picker to allow users to select start/end date to generate a given report. In ireport I created: Input Controls -> Single Value Type -> Date Type I see a Minimum Value and Maximum Value input fields there and a "is strict minimum" "is strict maximum" checkboxs. Is there a specific format I need to type in these fields in order to have the date picker start form a certain date? Currently, It looks like the date is: 12-31-1969 by default. Any help will be greatly appreciated ! thanks :)

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 !

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 ! :)