compare date variable with field value

[curiousfellow]

I have been struggling for hours now to get the correct  expression, so I hope you can help me.

I created a variable vMonthend_year_1:  =date(MonthEnd( addyears(today(),-1)),'DD-MM-YYYY')

When I use this expression in a textbox  it shows the correct value (30-11-2019) because current date is 25-11-2020.

When I use the variable in a textbox  like  = $(vMonthend_year_1) the result is -2000 (probably  30 minus 11 minus 2000)

When i use this expression in a textbox : date($(vMonthend_year_1) the result is 09-07-1894 (???)

All kinds of variations (with or without $  or use  " ") it doesn't help

I have to use this variable in a set analysis expression I kindly ask you to help me with this expression

{<fielddate= {"<= $(vMonthend_year_1)"}>}

A link to helpfull documentation about date variables would be appreciated to.

[Vegar · Accepted solution]

This is some alternative outputs if your system date format is YYYY-MM-DD

Take a look at attached qvw

[curiousfellow]

Thank you very much, this helps a lot. 

It looks like the answer is in the use of $