topic Re: How to get previous month first and last date? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378742#M702929 <HTML><HEAD></HEAD><BODY><P>Thank you!</P><P></P><P>These functions work excactly as I need <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 17 Aug 2012 10:41:03 GMT 2012-08-17T10:41:03Z How to get previous month first and last date? https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378740#M702927 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I would like to limit data that is imported into QlikView and for that we have a XML function that needs startdate=YYYYMMDD and enddate=YYYYMMDD set up.</P><P></P><P>I can currently change it manually to the first day of the previous month and to the last day of the previous month or take it from a variable. But as people accesing template over web cannot change variable, then reload is using date set there before.</P><P></P><P>Is there an function to add previous month first date and last date in format YYYYMMDD?</P><P></P><P>For example today it would give me 20120701 and 20120731.</P><P>In September it would give me 20120801 and 20120831?</P><P></P><P></P><P>Thank you in advance for any help!</P><P></P><P></P><P>Mariliis</P></BODY></HTML> Fri, 17 Aug 2012 09:14:44 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378740#M702927 2012-08-17T09:14:44Z Re: How to get previous month first and last date? https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378741#M702928 <HTML><HEAD></HEAD><BODY><P>=date(floor(monthstart(addmonths(Today(),-1))), 'YYYYMMDD')</P><P></P><P>and </P><P></P><P>=date(floor(monthend(addmonths(Today(),-1))), 'YYYYMMDD')</P></BODY></HTML> Fri, 17 Aug 2012 09:21:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378741#M702928 Anonymous 2012-08-17T09:21:41Z Re: How to get previous month first and last date? https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378742#M702929 <HTML><HEAD></HEAD><BODY><P>Thank you!</P><P></P><P>These functions work excactly as I need <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 17 Aug 2012 10:41:03 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/378742#M702929 2012-08-17T10:41:03Z Re: How to get previous month first and last date? https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/1621169#M702930 <P><SPAN>date(monthstart(Today(), -1),'YYYYMMDD')</SPAN></P> Fri, 06 Sep 2019 15:20:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-month-first-and-last-date/m-p/1621169#M702930 david_florian 2019-09-06T15:20:06Z