topic Re: date conversion? in QlikView https://community.qlik.com/t5/QlikView/date-conversion/m-p/749410#M267374 <HTML><HEAD></HEAD><BODY><P>Tresesco answer is right.</P></BODY></HTML> Thu, 19 Mar 2015 11:11:54 GMT hariprasadqv 2015-03-19T11:11:54Z date conversion? https://community.qlik.com/t5/QlikView/date-conversion/m-p/749407#M267371 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a date like this 2-jan-11</P><P></P><P>i want to convert it into 02/01/11 or 02/01/2011</P><P></P><P>Plz help me on this.</P></BODY></HTML> Thu, 19 Mar 2015 11:03:50 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/749407#M267371 2015-03-19T11:03:50Z Re: date conversion? https://community.qlik.com/t5/QlikView/date-conversion/m-p/749408#M267372 <HTML><HEAD></HEAD><BODY><P>Date(Date#('2-jan-11', 'DD-MMM-YY'), 'DD/MM/YY')</P></BODY></HTML> Thu, 19 Mar 2015 11:06:30 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/749408#M267372 tresB 2015-03-19T11:06:30Z Re: date conversion? https://community.qlik.com/t5/QlikView/date-conversion/m-p/749409#M267373 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try below</P><P>If it is valid date then</P><P>1)for 02/01/11</P><P>Date('2-jan-11','DD/MM/YY')</P><P></P><P>or</P><P>2) for 02/01/2011</P><P>Date('2-jan-11', 'DD/MM/YYYY')</P><P></P><P>If it is not valid date then</P><P>1)for 02/01/11</P><P>Date(Date#('2-jan-11', 'DD-MMM-YY'), 'DD/MM/YY')</P><P></P><P>or</P><P>2) for 02/01/2011</P><P>Date(Date#('2-jan-11', 'DD-MMM-YY'), 'DD/MM/YYYY')</P><P></P><P>Regards</P></BODY></HTML> Thu, 19 Mar 2015 11:09:24 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/749409#M267373 PrashantSangle 2015-03-19T11:09:24Z Re: date conversion? https://community.qlik.com/t5/QlikView/date-conversion/m-p/749410#M267374 <HTML><HEAD></HEAD><BODY><P>Tresesco answer is right.</P></BODY></HTML> Thu, 19 Mar 2015 11:11:54 GMT https://community.qlik.com/t5/QlikView/date-conversion/m-p/749410#M267374 hariprasadqv 2015-03-19T11:11:54Z