Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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
Author

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
MVP
MVP

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

Check attached.