Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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