topic Re: Date Calulation in QlikView https://community.qlik.com/t5/QlikView/Date-Calulation/m-p/1416600#M801085 <HTML><HEAD></HEAD><BODY><P>Addmonths(yourdate,-18)</P></BODY></HTML> Fri, 17 Nov 2017 18:16:25 GMT Clever_Anjos 2017-11-17T18:16:25Z Date Calulation https://community.qlik.com/t5/QlikView/Date-Calulation/m-p/1416599#M801084 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have expiration date for each ID.</P><P></P><P>How can I calculate 18 months prior to that given date ?</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Calulation/m-p/1416599#M801084 apthansh 2020-11-25T16:16:04Z Re: Date Calulation https://community.qlik.com/t5/QlikView/Date-Calulation/m-p/1416600#M801085 <HTML><HEAD></HEAD><BODY><P>Addmonths(yourdate,-18)</P></BODY></HTML> Fri, 17 Nov 2017 18:16:25 GMT https://community.qlik.com/t5/QlikView/Date-Calulation/m-p/1416600#M801085 Clever_Anjos 2017-11-17T18:16:25Z