11 Replies Latest reply: Jul 28, 2017 10:36 AM by Jorge Canelhas RSS

    Date comparison in expression

    Jorge Canelhas

      Hi all,

       

      I want to do a daily analisys so in the load script I have

       

      LET TodayDate = today();

       

      In the expression I compare with the field :

       

      dtimport_formated that is obtained from dtimport in mysql load by:

       

      CAST(dtimport AS DATE) as dtimport_formated

       

      dtimport is an integer in the format : 20170710

       

      the expression I use is

       

      Sum({<dtimport_formated={$(TodayDate)}>}valor_brt)

       

      it returns nothing, but...

       

      if I use

       

      LET TodayDate = date(today(),'YYYYMMDD');

       

      and then compare it with

       

      Sum({<dtimport={$(TodayDate)}>}valor_brt)


      it works fine, but the date instead of showing dd/MM/YYYY is presented in YYYYMMdd




      can anyone help ?