Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Converting general field from excel to datetime

hi everyone,

I want to know how to convert general field from excel to datetime. I have tried with date and date# functions but it is not giving me proper output.

excel file is attached herewith.

Please help with this

3 Replies
MVP
MVP

Re: Converting general field from excel to datetime

timestamp#() or date#() with an appropriate format code string should work. Worked for me:

LOAD timestamp#(Time,'YYYY.MM.DD hh:mm:ss.ffff') as Time,

     INV_1.AC_Pow.C2.AVG_WT0,

     INV_1.DC_Pow.C2.AVG_WT0,

     INV_1.Total_Energy.C2.MAX,

     INV_1.INV_No

FROM

SI01.xls

(biff, embedded labels, table is [Inverter1$]);

Not applicable

Re: Converting general field from excel to datetime

hey..

I tried with this solution.But still when I am extracting year from time as 'year(Time)' ,it is not giving me output.

MVP
MVP

Re: Re: Converting general field from excel to datetime

If you succesfully interpreted your Time field as timestamp, year(Time) does work.

Check attached.