topic Re: previous month to same day in QlikView https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732451#M1080833 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P><STRONG>InMonthToDate</STRONG> (date, Today(), -1) </P></BODY></HTML> Tue, 08 Jul 2014 11:02:47 GMT tresB 2014-07-08T11:02:47Z previous month to same day https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732450#M1080832 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i am trying to get an expression working that will show me the previous month but to same day.</P><P>i.e.</P><P></P><P>today is 8th July, so i would want previous month to be from 1st-8th June. </P><P>can anyone help please?</P></BODY></HTML> Tue, 08 Jul 2014 10:59:15 GMT https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732450#M1080832 hopkinsc 2014-07-08T10:59:15Z Re: previous month to same day https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732451#M1080833 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P><STRONG>InMonthToDate</STRONG> (date, Today(), -1) </P></BODY></HTML> Tue, 08 Jul 2014 11:02:47 GMT https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732451#M1080833 tresB 2014-07-08T11:02:47Z Re: previous month to same day https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732452#M1080834 <HTML><HEAD></HEAD><BODY><P>Maybe something like this:</P><P>sum({&lt;MyDateField={'&gt;=$(=num(monthstart(today(),-1)))&lt;=$(=num(addmonths(today(),-1)))'}&gt;} amount)</P></BODY></HTML> Tue, 08 Jul 2014 11:05:03 GMT https://community.qlik.com/t5/QlikView/previous-month-to-same-day/m-p/732452#M1080834 Gysbert_Wassenaar 2014-07-08T11:05:03Z