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




      it returns nothing, but...


      if I use


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


      and then compare it with



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

      can anyone help ?