topic DateTimestamp to Hour Only in QlikView https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278759#M622418 <HTML><HEAD></HEAD><BODY><P>Hi I have a DateTimeStamp (14/01/17&nbsp; 21:45)</P><P></P><P>I want to convert it to show Hour only (21) as a decimal.</P><P></P><P>Can anyone help?</P><P></P><P></P><P>Many thanks</P></BODY></HTML> Thu, 05 Jan 2017 12:49:19 GMT Anonymous 2017-01-05T12:49:19Z DateTimestamp to Hour Only https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278759#M622418 <HTML><HEAD></HEAD><BODY><P>Hi I have a DateTimeStamp (14/01/17&nbsp; 21:45)</P><P></P><P>I want to convert it to show Hour only (21) as a decimal.</P><P></P><P>Can anyone help?</P><P></P><P></P><P>Many thanks</P></BODY></HTML> Thu, 05 Jan 2017 12:49:19 GMT https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278759#M622418 Anonymous 2017-01-05T12:49:19Z Re: DateTimestamp to Hour Only https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278760#M622419 <HTML><HEAD></HEAD><BODY><P>You could just use: hour(DateTimeStamp) for it.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 05 Jan 2017 12:55:26 GMT https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278760#M622419 marcus_sommer 2017-01-05T12:55:26Z Re: DateTimestamp to Hour Only https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278761#M622420 <HTML><HEAD></HEAD><BODY><P>How funny !!</P><P></P><P>You can't imagine how many combinations of rounding combined with calculations.</P><P></P><P>Muppet moment for me. </P><P></P><P>Thanks Mark</P></BODY></HTML> Thu, 05 Jan 2017 13:02:14 GMT https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278761#M622420 Anonymous 2017-01-05T13:02:14Z Re: DateTimestamp to Hour Only https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278762#M622421 <HTML><HEAD></HEAD><BODY><P>Marcus (not Mark)</P></BODY></HTML> Thu, 05 Jan 2017 13:02:59 GMT https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278762#M622421 Anonymous 2017-01-05T13:02:59Z Re: DateTimestamp to Hour Only https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278763#M622422 <HTML><HEAD></HEAD><BODY><P>You want to see it in decimal?</P><P></P><P><STRONG>Ceil(Frac(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DateTimeStamp</SPAN>), 1/24)</STRONG></P></BODY></HTML> Thu, 05 Jan 2017 13:03:01 GMT https://community.qlik.com/t5/QlikView/DateTimestamp-to-Hour-Only/m-p/1278763#M622422 sunny_talwar 2017-01-05T13:03:01Z