topic Date functions in QlikView https://community.qlik.com/t5/QlikView/Date-functions/m-p/332617#M122571 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a date field in a list box. I have to display only the date part. Using format date I have displayed date alone. But duplicate values are available in the list box, as same date but different time are available. Please let me know how to remove the duplicate values.</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Wed, 04 Jul 2012 04:49:30 GMT krishnacbe 2012-07-04T04:49:30Z Date functions https://community.qlik.com/t5/QlikView/Date-functions/m-p/332617#M122571 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a date field in a list box. I have to display only the date part. Using format date I have displayed date alone. But duplicate values are available in the list box, as same date but different time are available. Please let me know how to remove the duplicate values.</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Wed, 04 Jul 2012 04:49:30 GMT https://community.qlik.com/t5/QlikView/Date-functions/m-p/332617#M122571 krishnacbe 2012-07-04T04:49:30Z Re: Date functions https://community.qlik.com/t5/QlikView/Date-functions/m-p/332618#M122572 <HTML><HEAD></HEAD><BODY><P>Hi, wrap your timestamp with Floor() to remove the decimal (i.e. time) part.</P></BODY></HTML> Wed, 04 Jul 2012 05:46:19 GMT https://community.qlik.com/t5/QlikView/Date-functions/m-p/332618#M122572 Anonymous 2012-07-04T05:46:19Z Re: Date functions https://community.qlik.com/t5/QlikView/Date-functions/m-p/332619#M122573 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Thanks for your quick response. </P></BODY></HTML> Wed, 04 Jul 2012 06:03:41 GMT https://community.qlik.com/t5/QlikView/Date-functions/m-p/332619#M122573 krishnacbe 2012-07-04T06:03:41Z