Chart dimension date between 2 variables

[#1]

Hi,

I have 2 variables, dateStart and dateEnd.

I have a chart in which the dimension is a field with dates.

I  would like the dimension to show only the values of the field which are between the 2 date variables - is it possible?

Thanks in advance,

Yael

[#2 · Accepted solution]

I have found the solution:

In the dimnsion, put the following expression; =if(DATE_FIELD>='$(dateStart )' AND DATE_FIELD<='$(dateEnd)' ,DATE_FIELD,Null)

And check the checkbox "Suppress when value is null"