Discussion board where members can get started with QlikView.
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
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,
(biff, embedded labels, table is [Inverter1$]);
I tried with this solution.But still when I am extracting year from time as 'year(Time)' ,it is not giving me output.
If you succesfully interpreted your Time field as timestamp, year(Time) does work.