Loading Data From Excel

[#1]

Hi All,

  I am new to Qlikview. I am loading data from Excel. Time field 'Estimated Start time' in Excel is in 'hh:mm TT' format  e.g '6.00 AM'. But  in qlikview after loading , Time field 'Estimated Start time' is coming like '6.00 a' inside of '6.00 AM'. So I use timestamp function.

Timestamp(Timestamp#([Estimated Start time (EST)],'hh:mm:ss TT'),'h:mm:ss TT') as Estimated_Start_time

   But after this I am not getting any data in Estimated_Start_time listbox.  Please suggest something.

[#2 · Accepted solution]

Please try this:

date([Estimated Start time (EST)], 'h:mm:ss TT')

Kind regards

[maxgro]

try with

Timestamp#([Estimated Start time (EST)],'hh:mm TT')

[#4]

Thank you so much.