topic Re: Time Formatting in QlikView https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473923#M177017 <HTML><HEAD></HEAD><BODY><P><OBJECT classid="CLSID:A806E1D7-B077-415E-AF08-28AFE10DDF4A" height="435" width="798"><PARAM name="_Version" value="720916" /><PARAM name="_ExtentX" value="21113" /><PARAM name="_ExtentY" value="11509" /><PARAM name="_StockProps" value="0" /><PARAM name="DocName" value="C:\Documents and Settings\anthony\Desktop\Qlikview\Salesforce\InvestmentMaster.qvw" /><PARAM name="UserName" value="" /><PARAM name="Password" value="" /><PARAM name="Publisher" value="" /><PARAM name="AccessMode" value="0" /><PARAM name="AllowDialog" value="1" /><PARAM name="SRC" value="" /><PARAM name="AutoScan" value="1" /><PARAM name="ProductLevel" value="22923860" /><PARAM name="ObjectID" value="Document\CH30" /></OBJECT></P></BODY></HTML> Thu, 21 Nov 2013 18:16:07 GMT anthony_kinsell 2013-11-21T18:16:07Z Time Formatting https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473922#M177016 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757;">I've got what I think will be a quite straightforward query. I'm trying to get just the time element of the below:</SPAN></P><P></P><P><SPAN style="color: #575757;">22/11/2012&nbsp; 10:30:00</SPAN></P><P></P><P><SPAN style="color: #575757;">The filed that gives this value is named 'ActivityDateTime ' so I put in the following formula:</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff;">Time</SPAN> <SPAN style="color: #0000ff;">(<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #800000;">ActivityDateTime</SPAN>,8)) <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">ViewingTime</SPAN>, </SPAN></P><P> </P><P><SPAN style="color: #575757;">This works only for some of my data which find odd?</SPAN></P></BODY></HTML> Thu, 21 Nov 2013 18:13:25 GMT https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473922#M177016 anthony_kinsell 2013-11-21T18:13:25Z Re: Time Formatting https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473923#M177017 <HTML><HEAD></HEAD><BODY><P><OBJECT classid="CLSID:A806E1D7-B077-415E-AF08-28AFE10DDF4A" height="435" width="798"><PARAM name="_Version" value="720916" /><PARAM name="_ExtentX" value="21113" /><PARAM name="_ExtentY" value="11509" /><PARAM name="_StockProps" value="0" /><PARAM name="DocName" value="C:\Documents and Settings\anthony\Desktop\Qlikview\Salesforce\InvestmentMaster.qvw" /><PARAM name="UserName" value="" /><PARAM name="Password" value="" /><PARAM name="Publisher" value="" /><PARAM name="AccessMode" value="0" /><PARAM name="AllowDialog" value="1" /><PARAM name="SRC" value="" /><PARAM name="AutoScan" value="1" /><PARAM name="ProductLevel" value="22923860" /><PARAM name="ObjectID" value="Document\CH30" /></OBJECT></P></BODY></HTML> Thu, 21 Nov 2013 18:16:07 GMT https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473923#M177017 anthony_kinsell 2013-11-21T18:16:07Z Re: Time Formatting https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473924#M177018 <HTML><HEAD></HEAD><BODY><P><STRONG>Anthony</STRONG></P><P></P><P>Try something like :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; time(ceil(date(date#('<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">22/11/2012 10:30:00</SPAN>' ; 'DD/MM/YYYY hh:mm:ss')</P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Thu, 21 Nov 2013 18:16:59 GMT https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473924#M177018 Anonymous 2013-11-21T18:16:59Z Re: Time Formatting https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473925#M177019 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Hope <SPAN style="color: #800000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">ActivityDateTime</SPAN> is datetime field, if so try like this</P><P></P><P><SPAN style="color: #800000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">Time(ActivityDateTime) As Time;</SPAN></P></BODY></HTML> Thu, 21 Nov 2013 18:21:04 GMT https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473925#M177019 MayilVahanan 2013-11-21T18:21:04Z Re: Time Formatting https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473926#M177020 <HTML><HEAD></HEAD><BODY><P>Thanks,</P><P></P><P>I was overcomplicating it!!</P></BODY></HTML> Thu, 21 Nov 2013 18:23:05 GMT https://community.qlik.com/t5/QlikView/Time-Formatting/m-p/473926#M177020 anthony_kinsell 2013-11-21T18:23:05Z