topic Change date format in QlikView https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444493#M165737 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When I upload my data through a qvd the date comes in the format mm\dd\yyyy in my chart</P><P></P><P>I need to get my date in the mmm - yy format </P><P></P><P>Please advise</P></BODY></HTML> Tue, 22 Jan 2013 16:43:03 GMT 2013-01-22T16:43:03Z Change date format https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444493#M165737 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>When I upload my data through a qvd the date comes in the format mm\dd\yyyy in my chart</P><P></P><P>I need to get my date in the mmm - yy format </P><P></P><P>Please advise</P></BODY></HTML> Tue, 22 Jan 2013 16:43:03 GMT https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444493#M165737 2013-01-22T16:43:03Z Re: Change date format https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444494#M165738 <HTML><HEAD></HEAD><BODY><P>You can use the date() function:</P><P></P><P>date(YourFieldName, 'MMM-YY')</P><P></P><P></P><P>Hope this helps</P><P>Fernando</P></BODY></HTML> Tue, 22 Jan 2013 17:12:33 GMT https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444494#M165738 fosuzuki 2013-01-22T17:12:33Z Re: Change date format https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444495#M165739 <HTML><HEAD></HEAD><BODY><P>Thank you so much. That worked perfectly <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 23 Jan 2013 09:51:05 GMT https://community.qlik.com/t5/QlikView/Change-date-format/m-p/444495#M165739 2013-01-23T09:51:05Z