topic Date format in QlikView https://community.qlik.com/t5/QlikView/Date-format/m-p/975213#M955182 <HTML><HEAD></HEAD><BODY><P>I use the following script for loading </P><P></P><P> ,&nbsp; Date#([Date Time],'YYYY-MM-DD') as [Date Time1]</P><P></P><P><IMG alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/105158_Sans titre.png" style="height: auto;" /></P><P></P><P>how to change date format for <SPAN style="font-size: 13.3333px;">Date Time1] to <SPAN style="font-size: 13.3333px;">YYYY-MM-DD?</SPAN></SPAN></P></BODY></HTML> Wed, 11 Nov 2015 12:38:34 GMT Anonymous 2015-11-11T12:38:34Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/975213#M955182 <HTML><HEAD></HEAD><BODY><P>I use the following script for loading </P><P></P><P> ,&nbsp; Date#([Date Time],'YYYY-MM-DD') as [Date Time1]</P><P></P><P><IMG alt="Sans titre.png" class="jive-image image-1" src="/legacyfs/online/105158_Sans titre.png" style="height: auto;" /></P><P></P><P>how to change date format for <SPAN style="font-size: 13.3333px;">Date Time1] to <SPAN style="font-size: 13.3333px;">YYYY-MM-DD?</SPAN></SPAN></P></BODY></HTML> Wed, 11 Nov 2015 12:38:34 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/975213#M955182 Anonymous 2015-11-11T12:38:34Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/975214#M955183 <HTML><HEAD></HEAD><BODY><P>use Format (what is the origin Format of Date Time?)</P><P>Date([Date Time],'YYYY-MM-DD') as [Date Time1]</P></BODY></HTML> Wed, 11 Nov 2015 12:41:23 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/975214#M955183 Anonymous 2015-11-11T12:41:23Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/975215#M955184 <HTML><HEAD></HEAD><BODY><P>Seems like the numbers were interpreted as text. Have you used a CROSSTABLE LOAD before this LOAD in question?</P><P></P><P>Try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date(num#([Date Time]),'YYYY-MM-DD') as [Date Time1]</SPAN></P></BODY></HTML> Wed, 11 Nov 2015 12:42:16 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/975215#M955184 swuehl 2015-11-11T12:42:16Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/975216#M955185 <HTML><HEAD></HEAD><BODY><P>Usefull reading: <A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P></BODY></HTML> Wed, 11 Nov 2015 12:42:28 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/975216#M955185 Clever_Anjos 2015-11-11T12:42:28Z