topic Re: Date conversion in QlikView https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444295#M1160642 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Assuming that '1-Aug-12' is a text field in your data source, then this should do it (just change the fieldname InputDate to the correct field name containing the 1-Aug-12 date string):</P><P></P><P>Date(Date#(InputDate, 'D-MMM-YY'), 'DD-MM-YYYY')</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 19 Nov 2012 09:49:47 GMT jonathandienst 2012-11-19T09:49:47Z Date conversion https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444293#M1160640 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>How to convert this text values of date into correct date values like 1-Aug-12 and </P><P></P><P>1-Aug-12 this to be conerted into</P><P></P><P>01-08-2012</P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 19 Nov 2012 09:43:16 GMT https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444293#M1160640 2012-11-19T09:43:16Z Re: Date conversion https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444294#M1160641 <HTML><HEAD></HEAD><BODY><P>date(date#('1-Aug-12','D-MMM-YY'), 'DD-MM-YYYY')</P></BODY></HTML> Mon, 19 Nov 2012 09:47:05 GMT https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444294#M1160641 Anonymous 2012-11-19T09:47:05Z Re: Date conversion https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444295#M1160642 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Assuming that '1-Aug-12' is a text field in your data source, then this should do it (just change the fieldname InputDate to the correct field name containing the 1-Aug-12 date string):</P><P></P><P>Date(Date#(InputDate, 'D-MMM-YY'), 'DD-MM-YYYY')</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Mon, 19 Nov 2012 09:49:47 GMT https://community.qlik.com/t5/QlikView/Date-conversion/m-p/444295#M1160642 jonathandienst 2012-11-19T09:49:47Z