Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Qlikview date function


I am new to Qlikview and trying to understand the functions.

What would this syntax mean:

ParcelLastLoadTime = DATE(0,'DD-MM-YYYY HH:MISmiley FrustratedS')

I understand that it is making the variable into date, but not sure what the 0 means.

Any help would really be appreciated.

thanks in advance.

1 Reply
Not applicable

Re: Qlikview date function

You remove the 0 and replace it with your field:


DATE(My_Field,'DD-MM-YYYY HH:MMSmiley FrustratedS') if your field holds the numeric value 41567 then it will return which is the date equivalent in the format you specified 20-10-2013 00:10:00.

Note the time format is : HH:MMSmiley FrustratedS not HH:MISmiley FrustratedS

The exact result of what your function will give you as is: 30-12-1899 00:12I:00

Community Browser