compare date variable with field value

curiousfellow — Sat, 16 Nov 2024 17:46:40 GMT

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.

Re: compare date variable with field value

Vegar — Wed, 25 Nov 2020 14:27:18 GMT

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

Take a look at attached qvw

curiousfellow — Wed, 25 Nov 2020 14:49:11 GMT

Thank you very much, this helps a lot.

It looks like the answer is in the use of $