Date variable in a set analysis

[Obsyky]

Hello,

I would like to use this type of measurement :

Sum({$<DATE_START={"<=$(=$(vDATEW))"}>}Weight)

DATE_START

05/07/2022

24/08/2022

22/09/2022

(There is almost one date line per day for 1 year)

If I enter 20/09/2022 in vDATEW, it doesn't work, but I think it comes from the date processing :

How can I solve this problem? Thank you

[MayilVahanan · Accepted solution]

hi

$() - indicates evaluate the expression.

If you mention $(vDATEW) - means, it will evaluate the values like 20 divide by 9 (result) divide by 2022.

In that case, you can simply use 

vDATEW

or

change the value of the vDATEW as "MakeDate(2022,09,22)" then, =$(vDATEW) it gives 20/9/2022 date value