topic Remove Timestamp in App Development https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400490#M32545 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to remove the timestamp on a date field.&nbsp; The date values are formatted as 2017-02-23T00:00:00.</P><P></P><P>I tried the following functions to remove the timestamp but, they all did not work.</P><P></P><UL><LI>Date(Floor(Date),'YYYY-MM-DD) As Date </LI><LI>Date(Date#(Left(Date,10),'YYYY-MM-DDT00:00:00'),'YYYY-MM-DD') As Date</LI><LI>Date(SubField(Date,' ',1)) As Date</LI></UL><P>Does anyone have suggestions as to how I can remove the timestamp?&nbsp; </P><P></P><P>Thank you in advance for any assistance!&nbsp; </P></BODY></HTML> Thu, 19 Oct 2017 22:54:01 GMT asmithids 2017-10-19T22:54:01Z Remove Timestamp https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400490#M32545 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to remove the timestamp on a date field.&nbsp; The date values are formatted as 2017-02-23T00:00:00.</P><P></P><P>I tried the following functions to remove the timestamp but, they all did not work.</P><P></P><UL><LI>Date(Floor(Date),'YYYY-MM-DD) As Date </LI><LI>Date(Date#(Left(Date,10),'YYYY-MM-DDT00:00:00'),'YYYY-MM-DD') As Date</LI><LI>Date(SubField(Date,' ',1)) As Date</LI></UL><P>Does anyone have suggestions as to how I can remove the timestamp?&nbsp; </P><P></P><P>Thank you in advance for any assistance!&nbsp; </P></BODY></HTML> Thu, 19 Oct 2017 22:54:01 GMT https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400490#M32545 asmithids 2017-10-19T22:54:01Z Re: Remove Timestamp https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400491#M32546 <HTML><HEAD></HEAD><BODY><P>FLOOR(&lt;datefield&gt;) AS Date</P><P></P><P>You can format that field, in the UI, to MM/DD/YYYY.&nbsp; Or whatever format you need.</P></BODY></HTML> Thu, 19 Oct 2017 23:01:06 GMT https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400491#M32546 Tanalex 2017-10-19T23:01:06Z Re: Remove Timestamp https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400492#M32547 <HTML><HEAD></HEAD><BODY><P>Thank you Michael!&nbsp; </P></BODY></HTML> Thu, 19 Oct 2017 23:30:35 GMT https://community.qlik.com/t5/App-Development/Remove-Timestamp/m-p/1400492#M32547 asmithids 2017-10-19T23:30:35Z