Not able to convert

[smilingjohn]

Hi Communtiy 

I am not able to convert the attached excel sheet  attachedn inot a proper date , year and weekly . 

I tried all the option of date conevrsion. Can please someone help to conevrt this date 

Thanks

[Vegar · Accepted solution]

Try using a date interpreter to define your date/timestamp.

It could look  something like this:

Load 

Dayname(tmp) as Date,

Year(tmp) as Year,

Mont(tmp) as Month ;

Load 

Timestamp#(Date, 'DD-MMM-YY hh.mm.ss.fff TT') as tmp

From source;

[zhadrakas]

This worked for me

Load Timestamp(Timestamp#(Date, 'DD-MMM-YY hh.mm.ss')) as Timestamp,
     Date(Timestamp#(Date, 'DD-MMM-YY hh.mm.ss')) as Date
;
LOAD subfield(Date, '.000000000', 1) as Date
FROM [Date-Convert.xlsx](ooxml, embedded labels, table is [Extracted for pmoid]);