topic Re: Time on Date in QlikView https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615065#M1117128 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>Date(date#(datefieldname,'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY')</P><P></P><P>******************************************************</P><P>DATE(FLOOR(DATEFIELDNAME))</P></BODY></HTML> Thu, 06 Feb 2014 12:01:33 GMT 2014-02-06T12:01:33Z Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615061#M1117124 <HTML><HEAD></HEAD><BODY><P>Hi, im sure this is a simple fix but didnt want to waste a couple of hours trying to figure it out.&nbsp; i have a table that shows dates, but the table it brings it from includes times as well.... how do i lose the times? (the imported table comes from a Syspro live database)</P><P></P><P>see attached</P></BODY></HTML> Thu, 06 Feb 2014 11:48:08 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615061#M1117124 Anonymous 2014-02-06T11:48:08Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615062#M1117125 <HTML><HEAD></HEAD><BODY><P>Hi James,</P><P>Use the Date() function.</P><P><STRONG>Date(Your_Field,'DD-MMM-YYYY')</STRONG></P></BODY></HTML> Thu, 06 Feb 2014 11:53:37 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615062#M1117125 jvishnuram 2014-02-06T11:53:37Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615063#M1117126 <HTML><HEAD></HEAD><BODY><P>or floor it to eliminate time</P></BODY></HTML> Thu, 06 Feb 2014 11:55:37 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615063#M1117126 giakoum 2014-02-06T11:55:37Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615064#M1117127 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">use Date(datefield,'DD-MM-YYYY')</STRONG></P></BODY></HTML> Thu, 06 Feb 2014 11:55:51 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615064#M1117127 manojkulkarni 2014-02-06T11:55:51Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615065#M1117128 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>Date(date#(datefieldname,'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY')</P><P></P><P>******************************************************</P><P>DATE(FLOOR(DATEFIELDNAME))</P></BODY></HTML> Thu, 06 Feb 2014 12:01:33 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615065#M1117128 2014-02-06T12:01:33Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615066#M1117129 <HTML><HEAD></HEAD><BODY><P>Manoj K :</P><P>how is that different from Vishnu Ram reply? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 06 Feb 2014 12:02:13 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615066#M1117129 giakoum 2014-02-06T12:02:13Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615067#M1117130 <HTML><HEAD></HEAD><BODY><P>Great, thanks everyone</P></BODY></HTML> Thu, 06 Feb 2014 12:02:35 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615067#M1117130 Anonymous 2014-02-06T12:02:35Z Re: Time on Date https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615068#M1117131 <HTML><HEAD></HEAD><BODY><P>both are same, by the time replying screen was yet to refresh i believe.</P></BODY></HTML> Thu, 06 Feb 2014 12:06:34 GMT https://community.qlik.com/t5/QlikView/Time-on-Date/m-p/615068#M1117131 manojkulkarni 2014-02-06T12:06:34Z