topic how to substract month from date in QlikView https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530850#M1129056 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a date field. I need to show records of last n months. So here I need to subtract given months from current date so that I'll get the date from where I need to display the records..</P><P></P><P>There is a function called AddMonths but I couldn't find such method for Substracting months. Can anybody plz guide me in subtracting given months from date?</P></BODY></HTML> Thu, 05 Dec 2013 05:50:06 GMT 2013-12-05T05:50:06Z how to substract month from date https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530850#M1129056 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a date field. I need to show records of last n months. So here I need to subtract given months from current date so that I'll get the date from where I need to display the records..</P><P></P><P>There is a function called AddMonths but I couldn't find such method for Substracting months. Can anybody plz guide me in subtracting given months from date?</P></BODY></HTML> Thu, 05 Dec 2013 05:50:06 GMT https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530850#M1129056 2013-12-05T05:50:06Z Re: how to substract month from date https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530851#M1129058 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you give months in -ve then it will subtract, check below example</P><P></P><P>=AddMonths(Today(), 1)&nbsp; -- 1/5/2014</P><P>=AddMonths(Today(), -1)&nbsp; -- 11/5/2013</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 05 Dec 2013 06:01:19 GMT https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530851#M1129058 jagan 2013-12-05T06:01:19Z Re: how to substract month from date https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530852#M1129059 <HTML><HEAD></HEAD><BODY><P>Thanku <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 05 Dec 2013 06:08:55 GMT https://community.qlik.com/t5/QlikView/how-to-substract-month-from-date/m-p/530852#M1129059 2013-12-05T06:08:55Z