Hi,

thanks for reaching out to us! In fact, storing values of type date into a variable and then comparing another date field with that list is a bit tricky. I replicated your issue and the following solution worked for me:

Within the button dropdown component, you can split the date into its year, month and date and store this value as a string into the variable:

YEAR(ACTIVITIES.EVENTTIME)

||-||

MONTH(ACTIVITIES.EVENTTIME)

||-||

DAY(ACTIVITIES.EVENTTIME)

Now, you simply need to use the same logic within your KPI. After the AND you can insert:

AND

YEAR(ACTIVITIES.EVENTTIME)

||-||

MONTH(ACTIVITIES.EVENTTIME)

||-||

DAY(ACTIVITIES.EVENTTIME)

NOT IN (<%= Cutoff %>)

You just need to exchange the column ACTIVITIES.EVENTTIME with your respective date column. This should lead to your desired result. The only downside of this solution is the dates representation within the dropdown component as leading zeros are not shown (e.g. February = 2 and not 02). However, if this is a problem for you, you can simply use a CASE WHEN statement within the above-proposed solution to add these leading zeros. If this solution does not work for you or you have another question, please feel free to reach out!