Problem in date formatting

[#1]

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 · Accepted solution]

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

[#3]

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 ?

[#5]

Thanks to all,