Date formatting problem for creating a Master Calendar

[#1]

Hi,

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

[Anonymous]

The date() function removes hh:mm:ss only from presentation, but not from the data, so the presentation can be changed back on the front end. Also, the same date, say 30.04.2009, will not be unique due to the different hh:mm:ss. So, using floor() function eliminates this issue. And, in addition, makes the files size smaller.

Regards,
Michael

[sathishkumar_go]

Hi Sparur,

I am not saying u r wrong. but my suggestion is depends on data format we use 'yyyy/mm/dd' or dd/mm/yyyy.

Regards,

Sathish