7 Replies Latest reply: Sep 19, 2013 6:03 AM by Celambarasan Adhimulam RSS

    CHANGE DATE FORMATE

    shariq ahmed

      Hi Grus!!!!

       

      i have an excel sheet with datee field in formate like (DD-MON-YYYY) i.e  23-SEP-2013

      but when i called this excel file in qlikview date shown lik 23/09/2013

       

      I want to show date like as in excel sheet.. 09 shuld be shown like SEP

      How to get this plz reply

      defult script is

      LOAD

      datee,

      category,

      expense_name,

      expense_amt

      from

      [C:\doc...........expense sheet.xlxs]

      (ooxml,embedded,labels,table is sheet1)

       

      if I change

      LOAD

      date(datee,'DD-MON-YYYY')

      category,

      expense_name,

      expense_amt

      from

      [C:\doc...........expense sheet.xlxs]

      (ooxml,embedded,labels,table is sheet1)

       

      ITS GIVE "23-9ON-2013" which is not understandable