Importing time data from QVD in QlikView

[NickBentley]

Hello,

I am running into an issue in my load script with the below:

Time(Time#(ERZET_SIMP_TM, 'HH:mm:ss') + MakeTime(14, 30, 0), 'HH:MM:SS') AS ORDER_ENTER_TIME_ACST

No matter how I tweak it the minutes are always coming in as the value '12'. 

Anyone got any suggestions? 

Thanks 🙂 

[mpc · Accepted solution]

Hi, 

Time(Time#(ERZET_SIMP_TM, 'hh:mm:ss') + MakeTime(14, 30, 0), 'hh:mm:ss') AS ORDER_ENTER_TIME_ACST maybe 
(lowercase in time format) ? Because MM refers to Month in Date. 

See attached file as example:
 

Kind regards