3 Replies Latest reply: Feb 23, 2015 9:44 PM by Antonio Caria RSS

    Urgent help: unable to convert datetime from xls to date in qlikview

      Dear all ,

       

      I have the attached data in my xls file. I want to conver the date format to YYYY-MM-DD using the below function but not works.

      =date#(date#(exceldatetimefiled, 'MM/DD/YYYY hh:mm'),'YYYY-MM-DD')

       

      input:

      datetime
      30/1/2015 13:25
      30/1/2015 11:47
      30/1/2015 11:39
      30/1/2015 9:48
      30/1/2015 9:25

       

      Output looking for is :

       

      date:

      2015-01-30

      Kindly help me.

       

      BR,

      Chinna