2 Replies Latest reply: Jul 26, 2011 11:02 PM by BlackRockS RSS

    Excel Date Format

    Milton Gianola

      Hi everyone!! I am a recently new QlikView Developer and I have a problem with Excel import data with date format.

       

      The cells that need to put in QlikView as a Date Format are with DateFormat in Excel, but after the load script the field always keep in number format, so I tried to format with the Date Functions but I can't do it well, and if give format number Date in Documents Properties either show me as number...

       

      Somebody can help me please!! The load script from excel it's  crosstable function...

       

      Thanks everybody!!!

      Milton