This content has been marked as final. Show 5 replies
It would be more easy if you limit values as less than or equals to current year.1 person found this helpful
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.
Thank You For Reply Alredy My Prompt Haveing Default values Like Current year and Current Month.
Let Me Know Where I can Write SQL. I Am Useing 11g.
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:
if helpful, pls mark correct/helpful
you can even put content filter at BMM layer of that particular time table.