Cast Current Date in Qlikview

Thu, 24 Jul 2014 08:24:49 GMT

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

Re: Cast Current Date in Qlikview

flipside — Thu, 24 Jul 2014 08:41:34 GMT

Hi,

Are you trying to pass a sql query via ODBC/OLEDB or convert the code to Qlikview load script?

topic Cast Current Date in Qlikview in QlikView

Cast Current Date in Qlikview

Re: Cast Current Date in Qlikview