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

    Qlikview date function

      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
          Carly McClintock


          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