https://community.qlik.com/t5/App-Development/Dates/m-p/1843461#M69803 <P>Hi All,</P><P>There was a requirement to automate some excel report using Qliksense.. Here , I read the data from excel files directly to qliksense.</P><P>In one of my logics&nbsp; &nbsp;I use:&nbsp; [MthYr] is my date variable</P><P>=IF(MthYr &gt;= date(AddMonths(today(),-2),'YYYYMM')and MthYr &lt;= date(AddMonths(today(),-1),'YYYYMM') , MthYr)</P><P>Example: today is 25-Sep-2021 , My report shows Aug data (All good)</P><P>Today is 2-Oct-2021, my logic gets refreshed and dtaa becomes zero .</P><P>I want to showcase only the last month data in my app. My data gets loaded everymonth between 11 to 15th..</P><P>Please help me modify the above logic so that it will not get refreshed automatically after 1st of everymonth..</P> Thu, 07 Oct 2021 10:06:03 GMT QS21 2021-10-07T10:06:03Z https://community.qlik.com/t5/App-Development/Dates/m-p/1843461#M69803 <P>Hi All,</P><P>There was a requirement to automate some excel report using Qliksense.. Here , I read the data from excel files directly to qliksense.</P><P>In one of my logics&nbsp; &nbsp;I use:&nbsp; [MthYr] is my date variable</P><P>=IF(MthYr &gt;= date(AddMonths(today(),-2),'YYYYMM')and MthYr &lt;= date(AddMonths(today(),-1),'YYYYMM') , MthYr)</P><P>Example: today is 25-Sep-2021 , My report shows Aug data (All good)</P><P>Today is 2-Oct-2021, my logic gets refreshed and dtaa becomes zero .</P><P>I want to showcase only the last month data in my app. My data gets loaded everymonth between 11 to 15th..</P><P>Please help me modify the above logic so that it will not get refreshed automatically after 1st of everymonth..</P> Thu, 07 Oct 2021 10:06:03 GMT https://community.qlik.com/t5/App-Development/Dates/m-p/1843461#M69803 QS21 2021-10-07T10:06:03Z