Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Is there away that the front end user can input a date range to filter the QVW? for example they may want to look at the information from between the dates of 01/01/11 to 20/09/11. Is there an easy way to do this?
Many Thanks
Emma
Hi Emma,
You can create two variables in the Settings menu, Variable Overview, vDateFrom and vDateTo. Then, create two slider / calendar objects, assining one variable to each of the objects, and set them to calendar, so when the user selects a date, it will be stored into those variables. To make it more clear, set in each calendar object a minimum and maximum value (the min and max dates in your document).
Then create a button, go to the button properties, Actions tab, Add, Selection, Select In Field, set your Date field, and in the Search string something like
='>=' & Date(vDateFrom) & '<=' & Date(vDateTo)
Hope that helps.
Miguel
Hi Emma,
You can create two variables in the Settings menu, Variable Overview, vDateFrom and vDateTo. Then, create two slider / calendar objects, assining one variable to each of the objects, and set them to calendar, so when the user selects a date, it will be stored into those variables. To make it more clear, set in each calendar object a minimum and maximum value (the min and max dates in your document).
Then create a button, go to the button properties, Actions tab, Add, Selection, Select In Field, set your Date field, and in the Search string something like
='>=' & Date(vDateFrom) & '<=' & Date(vDateTo)
Hope that helps.
Miguel
Check attached file
it contains the full solution of what you are asking for