Cast Current Date in Qlikview

[#1]

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

[flipside]

Hi,

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