Dynamic date prompts

[Chandrasekar]

Hi guru's,

I have two date prompts,
       1st one is 'FromDate' prompt name - last year is default selection.
       2nd one is 'ToDate' prompt name - current date is default selection, after the current date hidden to user selection view.

First one is i do well using javascript, Second one not get the solution.(current date only defaultly selected). I don't know how to hidden.

I am using 10.2 - Relational model.

Please share your knowledge.

Thanks & Regards,
Chandrasekar.

[Chandrasekar]

Hi Guru's,

I am attached sample xml backup for your reference. Please help me.

Thanks & Regards,
Chandrasekar.

[Chandrasekar]

Hi Guru's,

Please provide any solutions.

Thanks & Regards,
Chandrasekar.

[karthik.kadambi]

You can do this without JavaScript techniques.

Call the parameter ?FromYear? and create a default selection '1900'

Create a filter in your main query

(?FromYear? = '1900' and [Year] = [Current Year])
or
([Year] between ?FromYear? and ?ToYear?)

[Current Year] = extract(year,sysdate())