https://community.qlik.com/t5/QlikView/Date-appearing-in-2-different-formats/m-p/1607938#M736890 <P>hi,&nbsp;</P><P>could anyone please tell me why the date is appearing in 2 different formats?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16312iCA165B3F4A6CADAC/image-size/small?v=v2&amp;px=200" role="button" title="image.png" alt="image.png" /></span>i have created a calendar on this date but when i select it for a list box it appears as expected, but when i select it for a straight table its appearing as a number. how can i get it to appear as the date?</P> Wed, 25 Nov 2020 16:16:04 GMT anonymous1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Date-appearing-in-2-different-formats/m-p/1607938#M736890 <P>hi,&nbsp;</P><P>could anyone please tell me why the date is appearing in 2 different formats?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 200px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16312iCA165B3F4A6CADAC/image-size/small?v=v2&amp;px=200" role="button" title="image.png" alt="image.png" /></span>i have created a calendar on this date but when i select it for a list box it appears as expected, but when i select it for a straight table its appearing as a number. how can i get it to appear as the date?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-appearing-in-2-different-formats/m-p/1607938#M736890 anonymous1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Date-appearing-in-2-different-formats/m-p/1607947#M736891 <P>Hi,</P><P>you use an expression in your chart, so the value of a date is numeric.</P><P>You can set the display formatting under the tab numbers or edit the expression to&nbsp;</P><P>date(yourexpression)</P><P>Regards</P> Wed, 31 Jul 2019 09:49:57 GMT https://community.qlik.com/t5/QlikView/Date-appearing-in-2-different-formats/m-p/1607947#M736891 martinpohl 2019-07-31T09:49:57Z