topic Re: Date format in QlikView https://community.qlik.com/t5/QlikView/Date-format/m-p/1297574#M843381 <HTML><HEAD></HEAD><BODY><P>Thanks for your Immediate rly.</P></BODY></HTML> Tue, 11 Apr 2017 07:30:08 GMT Anonymous 2017-04-11T07:30:08Z Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1297571#M843378 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am having date format llike 30-11-2016.txt .how can i remove .txt from the date.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1297571#M843378 Anonymous 2020-11-25T16:16:04Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1297572#M843379 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><EM><STRONG>Purgechar</STRONG>(DateField, '.txt')</EM></P><P><EM>Or,</EM></P><P><EM><STRONG>SubField</STRONG>(DateField,'.' ,1) <BR /></EM></P></BODY></HTML> Tue, 11 Apr 2017 07:23:22 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1297572#M843379 tresB 2017-04-11T07:23:22Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1297573#M843380 <HTML><HEAD></HEAD><BODY><P>You can use many ways</P><P>1) SubField('30-11-2016.txt', '.', 1)</P><P>2) Replace('30-11-2016.txt', '.txt', '')</P><P>3) Left('30-11-2016.txt', 10)</P><P>4) PurgeChar('<SPAN style="font-size: 13.3333px;">'30-11-2016.txt', '.txt'</SPAN><EM style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">)</EM></P></BODY></HTML> Tue, 11 Apr 2017 07:25:34 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1297573#M843380 Anil_Babu_Samineni 2017-04-11T07:25:34Z Re: Date format https://community.qlik.com/t5/QlikView/Date-format/m-p/1297574#M843381 <HTML><HEAD></HEAD><BODY><P>Thanks for your Immediate rly.</P></BODY></HTML> Tue, 11 Apr 2017 07:30:08 GMT https://community.qlik.com/t5/QlikView/Date-format/m-p/1297574#M843381 Anonymous 2017-04-11T07:30:08Z