topic Re: Date Format in QlikView https://community.qlik.com/t5/QlikView/Date-Format/m-p/471299#M176029 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Try with <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/vishwaranjan" id="jive-10046115258235480446839" style="background-color: #ffffff; font-size: 11.818181991577148px; color: #007fc0; text-decoration: initial; font-weight: bold; font-family: Arial; text-align: center;">vishwaranjan</A> code. Its absolutely fine.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Also refer the attached link for more knowledge on date and time format </SPAN></P><H2 style="background-color: #ffffff; font-size: 1.8em; margin: 5px 0; font-weight: normal; color: #252525; font-family: Arial;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work" style="font-size: 21.81818199157715px; color: #252525;">Why don’t my dates work?</A></SPAN></H2></BODY></HTML> Tue, 26 Feb 2013 11:37:13 GMT manideep78 2013-02-26T11:37:13Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/471297#M176027 <HTML><HEAD></HEAD><BODY><P>Hey, </P><P></P><P>I'm having a little bit of an issue with the format of dates.</P><P></P><P>Dates are being Imported in the format 20120101 000000, So YYYYMMDD HHMMSS</P><P></P><P>However I would like it to just display as YYYY-MM-DD</P><P></P><P>Is there any way of doing this??</P><P></P><P>Thanks in advance!</P><P></P><P>Natalie</P></BODY></HTML> Tue, 26 Feb 2013 11:12:58 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/471297#M176027 2013-02-26T11:12:58Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/471298#M176028 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P><STRONG>DATE(DATE#('20120101 000000','YYYYMMDD hhmmss'),'YYYY-MM-DD')</STRONG></P></BODY></HTML> Tue, 26 Feb 2013 11:25:37 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/471298#M176028 2013-02-26T11:25:37Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/471299#M176029 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Try with <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/vishwaranjan" id="jive-10046115258235480446839" style="background-color: #ffffff; font-size: 11.818181991577148px; color: #007fc0; text-decoration: initial; font-weight: bold; font-family: Arial; text-align: center;">vishwaranjan</A> code. Its absolutely fine.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Also refer the attached link for more knowledge on date and time format </SPAN></P><H2 style="background-color: #ffffff; font-size: 1.8em; margin: 5px 0; font-weight: normal; color: #252525; font-family: Arial;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work" style="font-size: 21.81818199157715px; color: #252525;">Why don’t my dates work?</A></SPAN></H2></BODY></HTML> Tue, 26 Feb 2013 11:37:13 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/471299#M176029 manideep78 2013-02-26T11:37:13Z