topic Re: Selection of date format in QlikView https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352142#M1171037 <HTML><HEAD></HEAD><BODY><P>The correct way is to use the floor() function</P><P></P><P>Date(floor(DATE)) as Date</P><P></P><P>-Rob</P></BODY></HTML> Thu, 14 Jun 2012 04:59:13 GMT rwunderlich 2012-06-14T04:59:13Z Selection of date format https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352140#M1171035 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am extracting data with current format is datetime.</P><P>How would i change the date format as i only want to capture date only and discard the time in qlikview loading phase.</P><P></P><P>eg:</P><P></P><P>LOAD</P><P><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">datekeyin</SPAN><SPAN style="font-size: 8pt;">, </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Thanks.</SPAN></P></BODY></HTML> Thu, 14 Jun 2012 01:42:05 GMT https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352140#M1171035 2012-06-14T01:42:05Z Re: Selection of date format https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352141#M1171036 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>LOAD</P><P><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #800000; font-size: 8pt;">datekeyin</SPAN><SPAN style="font-size: 8pt;">, </SPAN></P><P><SPAN style="font-size: 8pt;">&nbsp;&nbsp;&nbsp;&nbsp; DATE(</SPAN><SPAN style="color: #800000; font-size: 8pt;">datekeyin,'DD-MM-YY'</SPAN><SPAN style="font-size: 8pt;">)&nbsp;&nbsp;&nbsp;&nbsp; AS [Dates]</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Sokkorn<BR /></SPAN></P></BODY></HTML> Thu, 14 Jun 2012 01:53:07 GMT https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352141#M1171036 Sokkorn 2012-06-14T01:53:07Z Re: Selection of date format https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352142#M1171037 <HTML><HEAD></HEAD><BODY><P>The correct way is to use the floor() function</P><P></P><P>Date(floor(DATE)) as Date</P><P></P><P>-Rob</P></BODY></HTML> Thu, 14 Jun 2012 04:59:13 GMT https://community.qlik.com/t5/QlikView/Selection-of-date-format/m-p/352142#M1171037 rwunderlich 2012-06-14T04:59:13Z