topic Re: Getdate in QlikView https://community.qlik.com/t5/QlikView/Getdate/m-p/414195#M154071 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>/Julia</P></BODY></HTML> Thu, 07 Feb 2013 13:28:19 GMT 2013-02-07T13:28:19Z Getdate https://community.qlik.com/t5/QlikView/Getdate/m-p/414192#M154068 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to make a date that is 12 month back and 36 month back.</P><P></P><P>If I write 12 as below I get -12 days.</P><P>Instead I want to remake 12 as month. How do I do that?</P><P></P><P></P><P>getdate()-12 as 12_month_back__date,</P><P></P><P></P><P>/Julia</P></BODY></HTML> Thu, 07 Feb 2013 13:15:30 GMT https://community.qlik.com/t5/QlikView/Getdate/m-p/414192#M154068 2013-02-07T13:15:30Z Re: Getdate https://community.qlik.com/t5/QlikView/Getdate/m-p/414193#M154069 <HTML><HEAD></HEAD><BODY><P>addmonths(today(),-12)&nbsp; as 12_month_back_date</P><P> addyears(today(),-3) as 3_year_back_date</P></BODY></HTML> Thu, 07 Feb 2013 13:26:03 GMT https://community.qlik.com/t5/QlikView/Getdate/m-p/414193#M154069 Gysbert_Wassenaar 2013-02-07T13:26:03Z Re: Getdate https://community.qlik.com/t5/QlikView/Getdate/m-p/414194#M154070 <HTML><HEAD></HEAD><BODY><P>Hi Peter,</P><P>you can use the function </P><P></P><P>addmonth(max(Date),-12)</P><P></P><P></P><P>Regards</P><P>Arun Reddy</P></BODY></HTML> Thu, 07 Feb 2013 13:27:13 GMT https://community.qlik.com/t5/QlikView/Getdate/m-p/414194#M154070 Anonymous 2013-02-07T13:27:13Z Re: Getdate https://community.qlik.com/t5/QlikView/Getdate/m-p/414195#M154071 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>/Julia</P></BODY></HTML> Thu, 07 Feb 2013 13:28:19 GMT https://community.qlik.com/t5/QlikView/Getdate/m-p/414195#M154071 2013-02-07T13:28:19Z