Create new variable

[munomet]

I have a problem while creating dynamic  values for variable input.

I set 1 variable (vDate1) with list of dates, and want this variable contain values from field REP_DATE_COMPARE only less than vDate1.

My code is :

=concat(distinct ({$<date([REP_DATE_COMPARE]) = {'<$(vDate1)'}>} date(REP_DATE_COMPARE)),'|')

What is wrong?

[tm_burgers]

what is the result of $(vDate1)? you say a list of dates...

the set expression formula you use will not work if your variable has more than one date value... 

[munomet]

$(vDate1) is variable with 1 date, selected from the list in drop down variable input

[tm_burgers]

Ok, the other thing I would do is change your set expression to, switch the variable to fully calculate by wrapping it in $(= ) and swap the single quotes for double.

distinct ({$<[REP_DATE_COMPARE] = {"$(=$(vDate1))"}>} REP_DATE_COMPARE)

I wouldn't wrap your dimension with Date - use your autoCalendar field if you need the format.