Set Date prompt to query data item

[axxo]

I have a query that finds the maximum start for financial year. What I want to do is to take that result and make it the default selection in my date prompt in my prompt page.

Does anyone know how to achieve this??

[prakashraju987]

Explain Breifly and will find the solution

[david.stachon]

Using the out-of-the-box date prompt objects I think you may be out of luck as you cannot attach a query to them.

[axxo]

Thanks for replies. Someone in my team says they have seen soemone else do itand we are waiting to hear back about it. Of course will post the answer if there is a working solution.

david.stachon, where can I get an out of the box prompt :o Please tell :)

prakashraju987, I have data spanning, lets say, 20 years. There is going to be 20 dates with first of July in this data source. What I want to do is find the latest most recent "first of July" (and I've done that already in a query)

The Problem: I want to take that result from THAT query and use it as the default selection in my date prompt.

[david.stachon]

...you know what you could do, instead of using "date prompts",

have three normal drop down lists:

one for each day, month and year. Those are easy enough to set values on. (and, very common on web-sites so people know how to use them)

As for setting it up on date prompts....you're looking at probably SDK or j-script. Both of which, means coding and probable difficulties in upgrading.

good luck!