topic Re: Converting general field from excel to datetime in QlikView

Converting general field from excel to datetime

Thu, 05 Sep 2013 10:30:38 GMT

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

swuehl — Thu, 05 Sep 2013 10:36:14 GMT

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

Thu, 05 Sep 2013 10:46:22 GMT

hey..

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

swuehl — Thu, 05 Sep 2013 11:33:55 GMT

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

Check attached.