topic Re: Date Format in QlikView https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228830#M622379 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Tue, 24 Jan 2017 20:48:28 GMT Anonymous 2017-01-24T20:48:28Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228827#M622376 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The record below is showing the correct date in my qvd file.</P><P><IMG alt="item1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/150755_item1.PNG" style="height: auto;" /></P><P></P><P>However, when I import the data in my dashboard the date format changes:</P><P><IMG alt="item 2.PNG" class="jive-image image-2" src="/legacyfs/online/150756_item 2.PNG" style="height: auto;" /></P><P>Please advise. Thanks!</P></BODY></HTML> Tue, 24 Jan 2017 20:10:13 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228827#M622376 Anonymous 2017-01-24T20:10:13Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228828#M622377 <HTML><HEAD></HEAD><BODY><P>Use Date() function while loading:</P><P></P><P><STRONG>Date(DateFieldName) as DateFieldName</STRONG></P></BODY></HTML> Tue, 24 Jan 2017 20:12:18 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228828#M622377 sunny_talwar 2017-01-24T20:12:18Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228829#M622378 <HTML><HEAD></HEAD><BODY><P>Adding Sunny's response, if you need a specific date format, you can add:</P><P></P><P>Date(DateFieldName,'MM-DD-YYYY') as DateFieldName<BR /><SPAN style="font-size: 13.3333px;">Date(DateFieldName,'MM/DD/YYYY') as DateFieldName</SPAN></P><P></P><P>Regards,</P></BODY></HTML> Tue, 24 Jan 2017 20:27:04 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228829#M622378 eespiritu 2017-01-24T20:27:04Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228830#M622379 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Tue, 24 Jan 2017 20:48:28 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228830#M622379 Anonymous 2017-01-24T20:48:28Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228831#M622380 <HTML><HEAD></HEAD><BODY><P>Thanks Enrique. When do we use Date#?</P></BODY></HTML> Tue, 24 Jan 2017 20:49:06 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228831#M622380 Anonymous 2017-01-24T20:49:06Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228832#M622381 <HTML><HEAD></HEAD><BODY><P>Read here:</P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Tue, 24 Jan 2017 20:51:49 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228832#M622381 sunny_talwar 2017-01-24T20:51:49Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228833#M622382 <HTML><HEAD></HEAD><BODY><P>You're welcome,</P><P></P><P>Check this discussion: <A _jive_internal="true" href="https://community.qlik.com/thread/157281">https://community.qlik.com/thread/157281</A></P></BODY></HTML> Tue, 24 Jan 2017 20:52:53 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1228833#M622382 eespiritu 2017-01-24T20:52:53Z