topic Re: Previous Month from text field in QlikView https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642089#M678804 <HTML><HEAD></HEAD><BODY><P>date(monthstart( date#([Effective Date], 'YYYYMMDD'),-1),'YYYYMM')</P></BODY></HTML> Wed, 21 May 2014 14:17:40 GMT Gysbert_Wassenaar 2014-05-21T14:17:40Z Previous Month from text field https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642088#M678803 <HTML><HEAD></HEAD><BODY><P>I have an "Effective Date" text field in the following format:</P><P></P><P>ex.&nbsp; Effective Date = 20140410&nbsp; ( April 10 of 2014)</P><P></P><P>I need to be able to change this to a text field that would represent the previous month (in a YYYYMM format):</P><P></P><P>20140410&nbsp; becomes 201403 </P><P>20140115&nbsp; becomes 201312</P><P></P><P>Thanks for any help in advance,</P><P></P><P>Steve</P></BODY></HTML> Wed, 21 May 2014 14:14:17 GMT https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642088#M678803 zagzebski 2014-05-21T14:14:17Z Re: Previous Month from text field https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642089#M678804 <HTML><HEAD></HEAD><BODY><P>date(monthstart( date#([Effective Date], 'YYYYMMDD'),-1),'YYYYMM')</P></BODY></HTML> Wed, 21 May 2014 14:17:40 GMT https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642089#M678804 Gysbert_Wassenaar 2014-05-21T14:17:40Z Re: Previous Month from text field https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642090#M678805 <HTML><HEAD></HEAD><BODY><P>Thanks! </P></BODY></HTML> Wed, 21 May 2014 14:36:53 GMT https://community.qlik.com/t5/QlikView/Previous-Month-from-text-field/m-p/642090#M678805 zagzebski 2014-05-21T14:36:53Z