Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in date formatting

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.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

View solution in original post

4 Replies
Miguel_Angel_Baeyens

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

View solution in original post

Not applicable
Author

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

from which data source u generate this excel ?

Not applicable
Author

Thanks to all,