topic Re: How to convert to a date format from the sample in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-to-a-date-format-from-the-sample/m-p/400599#M149081 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>date(date#('Fieldname','DD-MMM-YY hh.mm.ss[.fff]'),'DD/MM/YYYY hh.mm.ss')</P></BODY></HTML> Mon, 05 Nov 2012 09:09:55 GMT sivarajs 2012-11-05T09:09:55Z How to convert to a date format from the sample https://community.qlik.com/t5/QlikView/How-to-convert-to-a-date-format-from-the-sample/m-p/400598#M149080 <HTML><HEAD></HEAD><BODY><P>HI, </P><P></P><P></P><P>Kindly look @ sample.xls and let me know to convert the same into date</P><P></P><P></P><P>regards</P><P>venkat</P></BODY></HTML> Mon, 05 Nov 2012 08:58:26 GMT https://community.qlik.com/t5/QlikView/How-to-convert-to-a-date-format-from-the-sample/m-p/400598#M149080 2012-11-05T08:58:26Z Re: How to convert to a date format from the sample https://community.qlik.com/t5/QlikView/How-to-convert-to-a-date-format-from-the-sample/m-p/400599#M149081 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>date(date#('Fieldname','DD-MMM-YY hh.mm.ss[.fff]'),'DD/MM/YYYY hh.mm.ss')</P></BODY></HTML> Mon, 05 Nov 2012 09:09:55 GMT https://community.qlik.com/t5/QlikView/How-to-convert-to-a-date-format-from-the-sample/m-p/400599#M149081 sivarajs 2012-11-05T09:09:55Z