Set Analysys for Date

[gleybson_calyx]

Friends,

why is not this measure working?

Sum ({<VENCTO = {'<$ (vToday)'}>} ValorVencto)

Field VENCTO = DD/MM/YYYY

Variable = Date(Today(), 'DD/MM/YYYY')

If I put Sum ({<'24/01/2018'= {'$(vToday)'}>} ValorVencto) It works

Sum ({<VENCTO = {'24/01/2018'}>} ValorVencto) It works

I have tried in several ways like:

Sum ({<VENCTO_ANOMESDIA = {'<$(vToday)'}>} ValorVencto)

Field VENCTO = YYYYMMDD

Variable = Date(Today(), 'YYYYMMDD')

Sum ({<VENCTO_NUM = {'<$(vToday)'}>} ValorVencto)

Field VENCTO = 43124

Variable = NUM(Date(Today(), 'YYYYMMDD'))

NONE OF THESE MEASURES WORKED.

What am I doing wrong?

[petter]

Have you tried to move the first single quotation mark to steps to the right like this and enclosing the entire search in double quotation marks. You can not have a space between the $ and the ( either:

Sum( {<VENCTO={"<'$(vToday)'"}>} ValorVencto )

[gleybson_calyx]

Did not work.

Follow the picture.

[swuehl]

Have you defined your variable with a leading equal sign or without?

The Magic of Variables

The Little Equals Sign

[gleybson_calyx]

[swuehl · Accepted solution]

You should definitely use double quotes if you want to use a search:

Quotes in Set Analysis

And also have a look at

Dates in Set Analysis

So, in total try

Sum( {<VENCTO={"<$(vToday)"}>} ValorVencto )