Setting a date range with a button click

[qlikuser123]

Hello,

I am attempting to create a 90 day report button that will set a range of dates for a date variable. So far I have tried using the action "Select values in a field" with the following expression:

='>=' & Date(Today(),'DD-MM-YYYY') & '<=' & Date(Today()+90,'DD-MM-YYYY')

I have also tried using a similar expression with the "Set variable value" action.

I have not been able to get the button to function, however. I have verified that the Expiration_Date variable matches the date format in the expression.

I have also noticed that most of the dates are grayed out in the date picker.

If anyone can provide guidance on how to set up a 90 day report button and how to access all of the dates in the date picker, it would be much appreciated.

Thank you.

[F_B]

Hi @qlikuser123 ,

use the "Select values matching search criteria".