topic Re: Qlikview date function in QlikView

Qlikview date function

Thu, 20 Nov 2014 14:02:18 GMT

Hi,

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

What would this syntax mean:

ParcelLastLoadTime = DATE(0,'DD-MM-YYYY HH:MI:SS')

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.

Re: Qlikview date function

Thu, 20 Nov 2014 14:07:34 GMT

You remove the 0 and replace it with your field:

e.g

DATE(My_Field,'DD-MM-YYYY HH:MM:SS') 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:MM:SS not HH:MI:SS

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