topic Re: Problem With Date Function in QlikView https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649506#M670267 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;Date = {'&gt;$(=Date(Max(Date)-30))'}&gt;}Sales)</P><P>or</P><P>SUM({&lt;Date = {'&gt;$(=Date(Today()-30))'}&gt;}Sales)</P></BODY></HTML> Fri, 19 Sep 2014 12:13:42 GMT MK_QSL 2014-09-19T12:13:42Z Problem With Date Function https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649505#M670266 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have a date field . I want an expression for date greater than 30 days.</P><P>Date format(dd/mm/yyyy)</P><P></P><P>Date&gt;30 days.</P><P></P><P>how it can be done , plz help me and sort out me with this problem,</P><P></P><P>Thxs in Advance ,</P><P></P><P>harish</P></BODY></HTML> Fri, 19 Sep 2014 12:11:43 GMT https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649505#M670266 munna1317 2014-09-19T12:11:43Z Re: Problem With Date Function https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649506#M670267 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;Date = {'&gt;$(=Date(Max(Date)-30))'}&gt;}Sales)</P><P>or</P><P>SUM({&lt;Date = {'&gt;$(=Date(Today()-30))'}&gt;}Sales)</P></BODY></HTML> Fri, 19 Sep 2014 12:13:42 GMT https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649506#M670267 MK_QSL 2014-09-19T12:13:42Z Re: Problem With Date Function https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649507#M670268 <HTML><HEAD></HEAD><BODY><P>thxs manish</P></BODY></HTML> Fri, 19 Sep 2014 12:27:44 GMT https://community.qlik.com/t5/QlikView/Problem-With-Date-Function/m-p/649507#M670268 munna1317 2014-09-19T12:27:44Z