Discussion Board for collaboration on QlikView Scripting.
I am new to Qlikview and trying to understand the functions.
What would this syntax mean:
ParcelLastLoadTime = DATE(0,'DD-MM-YYYY HH:MIS')
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:
DATE(My_Field,'DD-MM-YYYY HH:MMS') 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:MMS not HH:MIS
The exact result of what your function will give you as is: 30-12-1899 00:12I:00