topic Re: Equivalent of DayStart for Hours? in App Development https://community.qlik.com/t5/App-Development/Equivalent-of-DayStart-for-Hours/m-p/25285#M1724 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Timestamp(Floor($(vTransactionDateTime), 1/24))</STRONG></P></BODY></HTML> Wed, 28 Feb 2018 17:16:39 GMT sunny_talwar 2018-02-28T17:16:39Z Equivalent of DayStart for Hours? https://community.qlik.com/t5/App-Development/Equivalent-of-DayStart-for-Hours/m-p/25284#M1723 <HTML><HEAD></HEAD><BODY><P>I'm trying to reproduce the result of DayStart() in the backend but at the hour level. My input data consists in <CODE>'DD/MM/YYYY hh:mm:ss'</CODE> timestamps.</P><P></P><P>I tried this :</P><P></P><P><CODE>Timestamp(Floor(($(vTransactionDateTime) * 24) / 24)) </CODE></P><P></P><P>but it returns rounded up data to the day level.</P><P></P><P>Any idea?</P></BODY></HTML> Wed, 28 Feb 2018 10:37:03 GMT https://community.qlik.com/t5/App-Development/Equivalent-of-DayStart-for-Hours/m-p/25284#M1723 rmnvncnt 2018-02-28T10:37:03Z Re: Equivalent of DayStart for Hours? https://community.qlik.com/t5/App-Development/Equivalent-of-DayStart-for-Hours/m-p/25285#M1724 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Timestamp(Floor($(vTransactionDateTime), 1/24))</STRONG></P></BODY></HTML> Wed, 28 Feb 2018 17:16:39 GMT https://community.qlik.com/t5/App-Development/Equivalent-of-DayStart-for-Hours/m-p/25285#M1724 sunny_talwar 2018-02-28T17:16:39Z