I Created Dashboard Prompt with 2column Like Year and Month.when User Select above year like 2013 Then showing msg or popup your select wrong value.At Same Time Month Also When select december(2012) Disply the message.
Please Any Help....
It would be more easy if you limit values as less than or equals to current year.
As you are expecting take more dev efforts and time.
Ex: year(current_date) in SQL at prompt.
Look for other simple options. Let us know updates.
If helps pls mark.
Do you want to go with SQL? then
In prompt Show->SQL Results use the query something like below
SELECT Time."Year" FROM "SA" where Time."Year"<=Year(current_date)
If you want to go with prompt kind I need to check possible ways..
If helps pls mark :)
Here are a few posts: