Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

Tags (3)
1 Reply
flipside
Valued Contributor II

Re: Cast Current Date in Qlikview

Hi,

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

Community Browser