topic Re: Set Analysys for Date in App Development

Set Analysys for Date

gleybson_calyx — Wed, 24 Jan 2018 18:06:35 GMT

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?

Re: Set Analysys for Date

petter — Wed, 24 Jan 2018 18:20:43 GMT

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 )

Re: Set Analysys for Date

gleybson_calyx — Wed, 24 Jan 2018 18:28:50 GMT

Did not work.

Follow the picture.

Re: Set Analysys for Date

swuehl — Wed, 24 Jan 2018 18:33:34 GMT

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

The Magic of Variables

The Little Equals Sign

Re: Set Analysys for Date

gleybson_calyx — Wed, 24 Jan 2018 18:36:39 GMT

Re: Set Analysys for Date

swuehl — Wed, 24 Jan 2018 22:55:55 GMT

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 )