topic Date and timestamp in QlikView https://community.qlik.com/t5/QlikView/Date-and-timestamp/m-p/176753#M44624 <HTML><HEAD></HEAD><BODY><P>I have a create date field that contains a date and timestamp. In my script , I use the statement below to take out the time stamp and merge all entries with the same day . This allows me to select all of a certain day/range of days easily. I am wondering if there is a similar statement that I can use to get rid of the date and merge the timestamps by hour. I would then be able to say, regarless of date, give me entries from this time to this time.</P><P></P><P>date(daystart(createdate),'MM/DD/YY') as CreateDayGL,</P><P></P><P>Any help is greatly appreciated.</P><P></P><P>Thanks!!</P></BODY></HTML> Fri, 04 Jun 2010 19:57:38 GMT 2010-06-04T19:57:38Z Date and timestamp https://community.qlik.com/t5/QlikView/Date-and-timestamp/m-p/176753#M44624 <HTML><HEAD></HEAD><BODY><P>I have a create date field that contains a date and timestamp. In my script , I use the statement below to take out the time stamp and merge all entries with the same day . This allows me to select all of a certain day/range of days easily. I am wondering if there is a similar statement that I can use to get rid of the date and merge the timestamps by hour. I would then be able to say, regarless of date, give me entries from this time to this time.</P><P></P><P>date(daystart(createdate),'MM/DD/YY') as CreateDayGL,</P><P></P><P>Any help is greatly appreciated.</P><P></P><P>Thanks!!</P></BODY></HTML> Fri, 04 Jun 2010 19:57:38 GMT https://community.qlik.com/t5/QlikView/Date-and-timestamp/m-p/176753#M44624 2010-06-04T19:57:38Z