5 Replies Latest reply: Jan 24, 2018 5:55 PM by Stefan Wühl RSS

    Set Analysys for Date

    Gleybson Fernandes

      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?