topic Re: Get Date Field for text in QlikView https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202447#M386969 <HTML><HEAD></HEAD><BODY><P>String functions:</P><P>Right(yourText, 7)</P><P>Replace(yourText, 'TotalC', '' ) </P></BODY></HTML> Tue, 01 Nov 2016 02:27:05 GMT Anonymous 2016-11-01T02:27:05Z Get Date Field for text https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202443#M386965 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have date field like this TotalCJan2015,TotalCFeb2015,TotalCMar2015,.....;</P><P>how can I get jan2015,Feb2015,Mar2015...;</P><P></P><P></P><P>Thanks Advanced</P></BODY></HTML> Mon, 31 Oct 2016 21:08:59 GMT https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202443#M386965 rish_sai 2016-10-31T21:08:59Z Re: Get Date Field for text https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202444#M386966 <HTML><HEAD></HEAD><BODY><P>try like this in script:</P><P></P><P>right(Field,7) as Field</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 31 Oct 2016 21:13:20 GMT https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202444#M386966 Frank_Hartmann 2016-10-31T21:13:20Z Re: Get Date Field for text https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202445#M386967 <HTML><HEAD></HEAD><BODY><P>date#(right([Your_Field_Name],7),'MMMYYYY')</P></BODY></HTML> Mon, 31 Oct 2016 21:14:09 GMT https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202445#M386967 Nicole-Smith 2016-10-31T21:14:09Z Re: Get Date Field for text https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202446#M386968 <HTML><HEAD></HEAD><BODY><P>=Replace( yourfield,'TotalC','')</P></BODY></HTML> Mon, 31 Oct 2016 22:22:29 GMT https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202446#M386968 robert_mika 2016-10-31T22:22:29Z Re: Get Date Field for text https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202447#M386969 <HTML><HEAD></HEAD><BODY><P>String functions:</P><P>Right(yourText, 7)</P><P>Replace(yourText, 'TotalC', '' ) </P></BODY></HTML> Tue, 01 Nov 2016 02:27:05 GMT https://community.qlik.com/t5/QlikView/Get-Date-Field-for-text/m-p/1202447#M386969 Anonymous 2016-11-01T02:27:05Z