Prompt display *** very urgent ***

[Nandini.t]

I have a year column which has entries from 1986 to 2012. i want the prompt to display all the previous years but not the current year and next years.
It means that "01/01/2011 -31/12/2011" will appear from 01/01/2012.
"you will only be able to select a year for the report once that year is completed.  2011 data only available once 31/12/2011 has passed".

Please let me know the steps to do this.

[HalfBloodPrince]

Hi its simple.
go to your prompt query , using query explore. here add filter on the year column as per ur requirement.
Thanks,

[Nandini.t]

 I got it....Thanks a lot :)