topic convert in QlikView https://community.qlik.com/t5/QlikView/convert/m-p/1178348#M889328 <HTML><HEAD></HEAD><BODY><P>hi All </P><P>I have a field name called Date and the date format in which is like below </P><P>How do i convert this date </P><P></P><P>11/30/2016 11:59 PM MST</P><P></P><P>into&nbsp; "DD-MM-YYY"(30-11-2016)</P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z convert https://community.qlik.com/t5/QlikView/convert/m-p/1178348#M889328 <HTML><HEAD></HEAD><BODY><P>hi All </P><P>I have a field name called Date and the date format in which is like below </P><P>How do i convert this date </P><P></P><P>11/30/2016 11:59 PM MST</P><P></P><P>into&nbsp; "DD-MM-YYY"(30-11-2016)</P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/convert/m-p/1178348#M889328 smilingjohn 2020-11-25T16:16:04Z Re: convert https://community.qlik.com/t5/QlikView/convert/m-p/1178349#M889329 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Date(Date#(SubField(Date, ' ', 1), 'MM/DD/YYYY'), 'DD-MM-YYYY') as Date</STRONG></P></BODY></HTML> Fri, 26 Aug 2016 11:36:27 GMT https://community.qlik.com/t5/QlikView/convert/m-p/1178349#M889329 sunny_talwar 2016-08-26T11:36:27Z