topic Re: Date Function in QlikView https://community.qlik.com/t5/QlikView/Date-Function/m-p/501893#M688308 <HTML><HEAD></HEAD><BODY><P><STRONG>Today() &gt; AddMonths(create_date,30)</STRONG>&nbsp; will return true (-1) if create_date is older than 30 months</P><P><STRONG>AddMonths(create_date,36) - Today()</STRONG>&nbsp; will return number of days left until 36 months</P></BODY></HTML> Wed, 27 Nov 2013 21:13:54 GMT nagaiank 2013-11-27T21:13:54Z Date Function https://community.qlik.com/t5/QlikView/Date-Function/m-p/501892#M688307 <HTML><HEAD></HEAD><BODY><P>I have a 'create_date' field and have to find if my create date is 30 months older than current date and also calculate how many days left until its 36 months old.How do I achieve that? </P></BODY></HTML> Wed, 27 Nov 2013 20:54:18 GMT https://community.qlik.com/t5/QlikView/Date-Function/m-p/501892#M688307 2013-11-27T20:54:18Z Re: Date Function https://community.qlik.com/t5/QlikView/Date-Function/m-p/501893#M688308 <HTML><HEAD></HEAD><BODY><P><STRONG>Today() &gt; AddMonths(create_date,30)</STRONG>&nbsp; will return true (-1) if create_date is older than 30 months</P><P><STRONG>AddMonths(create_date,36) - Today()</STRONG>&nbsp; will return number of days left until 36 months</P></BODY></HTML> Wed, 27 Nov 2013 21:13:54 GMT https://community.qlik.com/t5/QlikView/Date-Function/m-p/501893#M688308 nagaiank 2013-11-27T21:13:54Z