How to connect one dataset to other

Iira

Hi All,<br />
<br />
Parameters are date 'mm-dd-yyyy' format, however in the query, i need to provide as .... M1 (in format 'MON-yyyy') between ? and ?.<br />
However it doesn't worked.<br />
<br />
Then i tried it as M1 (in format 'MON-yyyy') between to_char(?,'MON-YYYY') and to_char(?,'MON-YYYY').<br />
still it is giving me -> <br />
input provided<br />
*From <strong class='bbc'>12/01/2010</strong><br />
* To <strong class='bbc'>12/30/2010</strong><br />
<br />
Output as DEC-10<br />
<br />
whereas for <br />
inputs as<br />
<br />
*From <strong class='bbc'>10/01/2010</strong><br />
* To <strong class='bbc'>12/30/2010</strong><br />
<br />
output is blank.<br />
<br />
So, if i take all the months between two dates in format "MON-YYYY" and take that values to the desired <br />
dataset, it could be helpful.<br />
Kindly help.

mwilliams

Hi Iira,

I'm not sure I'm quite understanding correctly, but you could try using the SimpleDateFormat() function to format your parameters in your dataSet's beforeOpen script how you'd like them to be and then pass them to your queryText in the script as well.