1 Reply Latest reply: Jul 24, 2014 4:41 AM by Dave Riley RSS

    Cast Current Date in Qlikview

      Hi! i'm trying to convert this SQL string in qlikview:

       

      case when FLOOR(CAST(CURRENT_DATE AS DATE) - CAST(a11.EXPIRE_DATE AS DATE)) < 0 then 0 else FLOOR(CAST(CURRENT_DATE AS DATE) - CAST(a11.EXPIRE_DATE AS DATE)) end


      I tried many times but I think the problem is in converting "CAST(CURRENT_DATE AS DATE)" in the right way.

      So someone have the solution at this problem??

      Thanks