Using a date variable within a set analysis

[DutchHans]

I have a constant date in a set analysis formula as stated below:

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=5-03-2020"}>}Bedrag)

What I want is to replace the date with a variable. Note that there is also a comparison "<=" (smaller or equal to) in the equation.

I know that I have to use $(VariableName) but I do not succeed in a workable solution.

[PradeepK · Accepted solution]

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=$(=vName)"}>}Bedrag)

where vName is your variable.

Refer to my reply from this post - Link