topic Re: Not able to convert in QlikView

Not able to convert

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Not able to convert

Vegar — Fri, 22 May 2020 05:40:38 GMT

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;

Re: Not able to convert

zhadrakas — Fri, 22 May 2020 05:47:20 GMT

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]);