Change Date Prompt to a Value Prompt

[ag]

Hi All,
I have a date prompt where the user clicks on the date. I need to change it to a Value prompt that shows all the dates in the dbase for the chosen date field. Thanks in advance for any ideas/help!
Andy

[BigChris]

Hi,

There are probably several ways, but the way I tend to do that sort of thing is to first create a query to select the dates from the database. Then create a value prompt on the prompt page, and point it at your new query. Make sure your new value prompt is being used for the same parameter that your original date prompt was using, and you should be good to go. Test it to make sure then delete your original date prompt once you've checked that it's working correctly.

[Mimo91]

Hi All,
I have a date prompt where the user clicks on the date. I need to change it to a Value prompt that shows all the dates in the dbase for the chosen date field. Thanks in advance for any ideas/help!
Andy

Hi,

Create a new query. Pull the date field from your package inside that query as a data item. In prompt page create a value prompt and assign this query to it. Use that date data item as use and display value of that value prompt.

If that date field is not available in you package, you can create the query using SQL plugin.