1 Reply Latest reply: Nov 20, 2014 9:09 AM by Carly McClintock RSS

    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: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

          You remove the 0 and replace it with your field:




          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