https://community.qlik.com/t5/QlikView/Convert-Timestamp-to-Date-field-and-Hour-Field/m-p/1699964#M724488 <P><FONT face="courier new,courier"><SPAN>Date(Floor(Timestamp#(Date_Time,'M-DD-YYYY hh:mm:ss[.fff]')),'M/DD/YYYY')</SPAN></FONT></P><P><FONT face="courier new,courier"><SPAN>Hour(Timestamp#(Date_Time,'M-DD-YYYY hh:mm:ss[.fff]'))</SPAN></FONT></P><P>-Rob<BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A><BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A></P> Thu, 07 May 2020 18:35:58 GMT rwunderlich 2020-05-07T18:35:58Z https://community.qlik.com/t5/QlikView/Convert-Timestamp-to-Date-field-and-Hour-Field/m-p/1699945#M724487 <P>Hello!&nbsp;</P><P>&nbsp;</P><P>How do I convert this timestamp 5/1/2020 15:02:54.123 to just a Date field: 5/1/2020 and hour field to round off to just say 9,10,11,12,13 etc...</P><P>Date:</P><P>05/01/2020</P><P>Hour:</P><P>14</P><P>I have tried&nbsp;Date(Timestamp#(Date_Time,'M-DD-YYYY HH:MM:SS.SSS'),'M/DD/YYYY')</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:43:23 GMT https://community.qlik.com/t5/QlikView/Convert-Timestamp-to-Date-field-and-Hour-Field/m-p/1699945#M724487 neena123 2024-11-16T00:43:23Z https://community.qlik.com/t5/QlikView/Convert-Timestamp-to-Date-field-and-Hour-Field/m-p/1699964#M724488 <P><FONT face="courier new,courier"><SPAN>Date(Floor(Timestamp#(Date_Time,'M-DD-YYYY hh:mm:ss[.fff]')),'M/DD/YYYY')</SPAN></FONT></P><P><FONT face="courier new,courier"><SPAN>Hour(Timestamp#(Date_Time,'M-DD-YYYY hh:mm:ss[.fff]'))</SPAN></FONT></P><P>-Rob<BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A><BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A></P> Thu, 07 May 2020 18:35:58 GMT https://community.qlik.com/t5/QlikView/Convert-Timestamp-to-Date-field-and-Hour-Field/m-p/1699964#M724488 rwunderlich 2020-05-07T18:35:58Z