https://community.qlik.com/t5/QlikView/Date-Format/m-p/1866648#M1216349 <P>maybe helpful:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178</A></P> <P>&nbsp;</P> Fri, 03 Dec 2021 17:30:00 GMT MarcoWedel 2021-12-03T17:30:00Z https://community.qlik.com/t5/QlikView/Date-Format/m-p/1866310#M1216337 <P>Hello,</P> <P>I have a field named Date inside qvw script and the dates are loaded from a excel sheet,where the format is not specified and i cannot edit in the script also.Now when i try visualising the dates data in a listbox,it is displayed in MM-DD-YYYY,and i want in MMM-YY.But when i give format in number section and also tried using date() function.After giving format here,it is listed wrongly.<BR />01-02-2021 is shown as Jan-02.(its actually feb-21)<BR />How can we sort it properly</P> <P>2.Will calendar object work if it inherits a state?</P> Fri, 03 Dec 2021 05:29:49 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1866310#M1216337 Athira_K 2021-12-03T05:29:49Z https://community.qlik.com/t5/QlikView/Date-Format/m-p/1866648#M1216349 <P>maybe helpful:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178</A></P> <P>&nbsp;</P> Fri, 03 Dec 2021 17:30:00 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/1866648#M1216349 MarcoWedel 2021-12-03T17:30:00Z