Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This is some alternative outputs if your system date format is YYYY-MM-DD
Take a look at attached qvw
This is some alternative outputs if your system date format is YYYY-MM-DD
Take a look at attached qvw
Thank you very much, this helps a lot.
It looks like the answer is in the use of $