https://community.qlik.com/t5/App-Development/Importing-time-data-from-QVD-in-QlikView/m-p/2486506#M101418 <P>Hi,&nbsp;</P> <P><SPAN>Time(Time#(ERZET_SIMP_TM, 'hh:mm:ss') + MakeTime(14, 30, 0), 'hh:mm:ss') AS ORDER_ENTER_TIME_ACST maybe&nbsp;<BR /></SPAN>(lowercase in time format) ? Because MM refers to Month in Date.&nbsp;<BR /><BR />See attached file as example:<BR />&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mpc_0-1728630420740.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/172798iFB0B4D03DA56EA71/image-size/medium?v=v2&amp;px=400" role="button" title="mpc_0-1728630420740.png" alt="mpc_0-1728630420740.png" /></span></P> <P><BR />Kind regards</P> <P>&nbsp;</P> Fri, 11 Oct 2024 07:07:10 GMT mpc 2024-10-11T07:07:10Z https://community.qlik.com/t5/App-Development/Importing-time-data-from-QVD-in-QlikView/m-p/2486483#M101417 <P>Hello,</P> <P>I am running into an issue in my load script with the below:</P> <P>Time(Time#(ERZET_SIMP_TM, 'HH:mm:ss') + MakeTime(14, 30, 0), 'HH:MM:SS') AS ORDER_ENTER_TIME_ACST</P> <P>No matter how I tweak it the minutes are always coming in as the value '12'.&nbsp;</P> <P>Anyone got any suggestions?&nbsp;</P> <P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 16 Nov 2024 16:35:16 GMT https://community.qlik.com/t5/App-Development/Importing-time-data-from-QVD-in-QlikView/m-p/2486483#M101417 NickBentley 2024-11-16T16:35:16Z https://community.qlik.com/t5/App-Development/Importing-time-data-from-QVD-in-QlikView/m-p/2486506#M101418 <P>Hi,&nbsp;</P> <P><SPAN>Time(Time#(ERZET_SIMP_TM, 'hh:mm:ss') + MakeTime(14, 30, 0), 'hh:mm:ss') AS ORDER_ENTER_TIME_ACST maybe&nbsp;<BR /></SPAN>(lowercase in time format) ? Because MM refers to Month in Date.&nbsp;<BR /><BR />See attached file as example:<BR />&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mpc_0-1728630420740.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/172798iFB0B4D03DA56EA71/image-size/medium?v=v2&amp;px=400" role="button" title="mpc_0-1728630420740.png" alt="mpc_0-1728630420740.png" /></span></P> <P><BR />Kind regards</P> <P>&nbsp;</P> Fri, 11 Oct 2024 07:07:10 GMT https://community.qlik.com/t5/App-Development/Importing-time-data-from-QVD-in-QlikView/m-p/2486506#M101418 mpc 2024-10-11T07:07:10Z