11 Replies Latest reply: Apr 30, 2009 4:05 PM by Sathish G RSS

    Date formatting problem for creating a Master Calendar


      I have a basic problem, I would like to create a Master Calendar. But I have problems in how to convert my "Date" in a adequate format.

      I have a timestamp as Date in the format 'YYYY-MM-DD hh:mm:ss' and I would use this field to make my Master Calendar, for that I think I must convert it in a new field with the format 'DD.MM.YYYY' ==> I don`t now how to convert a timestamp in the dateformat which I mentioned above. For Example my basic timestamp of an excel file is ==> 2008-09-22 10:24:54 ==> must convert it in the format ==> 22.09.2008

      And with this field with the right format than I can make a calendar which is described for example in the QlikView Cookbook.

      Basic Setup of the Application

      SET ThousandSep='.';
      SET DecimalSep=',';
      SET MoneyThousandSep='.';
      SET MoneyDecimalSep=',';
      SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
      SET TimeFormat='hh:mm:ss';
      SET DateFormat='DD.MM.YYYY';
      SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
      SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
      SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

      I hope somebody could help me? Thanks