Prompt

[Former Member]

Hi All,

I have a scenario as below.

i have prompt on 'Year' and 'Month'

Eg: 2010, 01

When i chose above prompt i must get data between 2009,01 and 2010,01

Pls help me to get the result?

[Former Member]

Thanks for the help it is working

[former_member142702]

Hi

what kind of data source are you getting data from?

Regards,

Stratos

[Former Member]

Thanks for early response..........

Oracle 10 G

BOXIR3 ......on AIX

Edited by: RBolla on Feb 9, 2010 9:11 AM

Edited by: RBolla on Feb 9, 2010 9:12 AM

[former_member142702]

Hi

you have to build a filter that creates the required SQL statement:

eg. (this is pseudo code)

<yourtable>.<your_date_column> between To_date(@prompt('Enter YYYYMM',....),<format of your input>) AND Add_months(To_date(@prompt('Enter YYYYMM',....),<format of your input>), <number of the months>)

Regards,

Stratos