topic Re: Date format in QlikView https://community.qlik.com/t5/QlikView/Date-format/m-p/1016641#M344421 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Date(ReloadTime(), 'DD-MMM-YYYY')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119896_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 30 Mar 2016 14:33:47 GMT sunny_talwar 2016-03-30T14:33:47Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1016640#M344420 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to show the last reload time as '01-Jan-2015 rather than 01-01-2015</P><P></P><P>Kindly advise.</P><P></P><P>Regards,</P><P>Mahamed</P></BODY></HTML> Wed, 30 Mar 2016 14:32:48 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1016640#M344420 Mahamed_Qlik 2016-03-30T14:32:48Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1016641#M344421 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Date(ReloadTime(), 'DD-MMM-YYYY')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119896_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 30 Mar 2016 14:33:47 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1016641#M344421 sunny_talwar 2016-03-30T14:33:47Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1016642#M344422 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>No. It is giving me 29-3-2016. </P></BODY></HTML> Wed, 30 Mar 2016 14:45:50 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1016642#M344422 Mahamed_Qlik 2016-03-30T14:45:50Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1016643#M344423 <HTML><HEAD></HEAD><BODY><P>by changing <SPAN style="font-size: 13.3333px;">TimestampFormat u maybe get solution.</SPAN></P><P></P><P>SET TimestampFormat='DD.MMM.YYYY';</P><P></P><P><IMG alt="qlik.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119902_qlik.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 30 Mar 2016 14:46:01 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1016643#M344423 imrencimen 2016-03-30T14:46:01Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1016644#M344424 <HTML><HEAD></HEAD><BODY><P>=date(Date#(relaodtime(),'DD-MMM-YYYY'),'DD-MM-YYYY') </P></BODY></HTML> Wed, 30 Mar 2016 14:46:43 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1016644#M344424 Chanty4u 2016-03-30T14:46:43Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1016645#M344425 <HTML><HEAD></HEAD><BODY><P>Do you have this environmental variable when you reload your application?</P><P></P><P><STRONG>SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; </STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119905_Capture.PNG" style="height: 222px; width: 620px;" /></P></BODY></HTML> Wed, 30 Mar 2016 14:49:54 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1016645#M344425 sunny_talwar 2016-03-30T14:49:54Z