topic Problem in date formatting in QlikView

Problem in date formatting

Tue, 30 Aug 2011 10:12:04 GMT

Hi all,

Please find the attached xl. In my database my date formate is like that what i am attached.

so, from that only i am going to create date field.

The problem is.

I did all formatting steps in my edit script but still i cant get the correct formate.

Anybody facing the similiar problem before.

Any solution.

Please let me know

Regards,

Sri.

Miguel_Angel_Baeyens — Tue, 30 Aug 2011 10:14:23 GMT

Hi Sri,

The following should work

Dates:
LOAD [no], 
     Date(Date#(Date, 'YYYYMMDD')) AS Date
FROM
Date.xlsx
(ooxml, embedded labels, table is Sheet1);

You first do the representation with the Date#() function, then the interpretation as date with the Date() function.

Hope that helps.

BI Consultant

Tue, 30 Aug 2011 10:16:10 GMT

Hi,

What are those zeros in date column, if you dont need them then use where to filter out them. Then use

makedate ( left ( date, 4 ), mid ( date, 5, 2 ), right(date, 2 )) as newdate.

HTH

Reg,

Shubhu

vikasmahajan — Tue, 30 Aug 2011 10:16:36 GMT

from which data source u generate this excel ?

Tue, 30 Aug 2011 10:41:12 GMT

Thanks to all,