https://community.qlik.com/t5/Reporting-Service-Alerting/Searching-for-data-for-the-last-month/m-p/2435726#M935 <P>see it like this<BR /><BR /></P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução" aria-label="Texto traduzido" data-ved="2ahUKEwis86SAv5eFAxWqrpUCHZ0mD5cQ3ewLegQIBRAU"><SPAN class="Y2IQFc">$(=(MonthStart(Date((Today(1))),-1) )) - '01/02/2024'<BR />$(=(MonthEnd(Date((today(1))),-1))) - '29/02/2024'<BR /></SPAN></PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><BR />Regarts, Matheus<BR /><BR /><BR /></P> Thu, 28 Mar 2024 17:38:03 GMT MatheusC 2024-03-28T17:38:03Z https://community.qlik.com/t5/Reporting-Service-Alerting/Searching-for-data-for-the-last-month/m-p/2435711#M934 <P>Hi,</P> <P>I'm a bit new to qlik and am building a report template. I have created a filter which has a search expression as follows:</P> <P>= (DueDate &gt;= Date('01/02/2024') AND DueDate &lt;= Date('29/02/2024'))</P> <P>Is there a way to make this dynamic so that I don't have to hardcode the previous month like above etc?</P> <P>&nbsp;</P> <P>Thanks for any help!</P> Thu, 28 Mar 2024 16:17:24 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Searching-for-data-for-the-last-month/m-p/2435711#M934 Zub 2024-03-28T16:17:24Z https://community.qlik.com/t5/Reporting-Service-Alerting/Searching-for-data-for-the-last-month/m-p/2435726#M935 <P>see it like this<BR /><BR /></P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução" aria-label="Texto traduzido" data-ved="2ahUKEwis86SAv5eFAxWqrpUCHZ0mD5cQ3ewLegQIBRAU"><SPAN class="Y2IQFc">$(=(MonthStart(Date((Today(1))),-1) )) - '01/02/2024'<BR />$(=(MonthEnd(Date((today(1))),-1))) - '29/02/2024'<BR /></SPAN></PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><BR />Regarts, Matheus<BR /><BR /><BR /></P> Thu, 28 Mar 2024 17:38:03 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Searching-for-data-for-the-last-month/m-p/2435726#M935 MatheusC 2024-03-28T17:38:03Z