Dynamically change the default selection of a prompt

[nald_p56]

Hi!

Is there a way to dynamically change the default selection of a prompt based on ther current day?

Or even even in terms of numbers? if today is august 6, then the value of ?Test_Prompt? = 6.

We created javascript to handle this, but the script will run only once the prompt page is loaded, so if the report is scheduled, then the value of the ?Test_Prompt? is not being populated.


Thankz!

[COGNOiSe administrator]

Depends. Certaing prompt behavior can be arranged at FM #prompt# level.

[John]

nald_p56, could you post your javascript to mention? and have you resolved this issue, i am looking for the same solution.
John

[COGNOiSe administrator]

CurrentDate (and other time ranges) can be passed if #prompt# macro is leveraged at the Framework Manager Model level, as you can specify default value for a prompt. Then scheduled or not, it will always bevahe the same way.

[vijayab]

Hi

extract(month,current_date)

Try this function,it extracts the Number of the Current month....

:)