topic Date Format problem - removing leading 0 in QlikView https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199469#M58386 <HTML><HEAD></HEAD><BODY><P>My dates come into qlikview as 06/09/2011 but the data in the CSV is 6/9/2011. I want my dates to use the CSV format of 6/9/2011. I used</P><P>M/D/YYY in my date#() function and still the leading zero shows up in qlikview.</P></BODY></HTML> Wed, 06 Apr 2011 01:05:27 GMT 2011-04-06T01:05:27Z Date Format problem - removing leading 0 https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199469#M58386 <HTML><HEAD></HEAD><BODY><P>My dates come into qlikview as 06/09/2011 but the data in the CSV is 6/9/2011. I want my dates to use the CSV format of 6/9/2011. I used</P><P>M/D/YYY in my date#() function and still the leading zero shows up in qlikview.</P></BODY></HTML> Wed, 06 Apr 2011 01:05:27 GMT https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199469#M58386 2011-04-06T01:05:27Z Date Format problem - removing leading 0 https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199470#M58387 <HTML><HEAD></HEAD><BODY><P>Try Date() instead of Date#()</P></BODY></HTML> Wed, 06 Apr 2011 02:17:32 GMT https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199470#M58387 2011-04-06T02:17:32Z Date Format problem - removing leading 0 https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199471#M58388 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG>debbiepy</STRONG> ,</P><P>Try like this..</P><P>Date(DateFieldName,'M/D/YYYY')</P><P></P></BODY></HTML> Wed, 06 Apr 2011 05:05:05 GMT https://community.qlik.com/t5/QlikView/Date-Format-problem-removing-leading-0/m-p/199471#M58388 2011-04-06T05:05:05Z