topic Re: Determine Previous MonthEnd in QlikView https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645071#M677822 <HTML><HEAD></HEAD><BODY><P>monthend(today(),-1)</P></BODY></HTML> Mon, 09 Jun 2014 17:29:18 GMT Gysbert_Wassenaar 2014-06-09T17:29:18Z Determine Previous MonthEnd https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645068#M677819 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am interested in an expression that will return the previous month end date. I was able to figure out that MonthEnd(today()) gives the current month's end date. I just want it for the month before instead. Is there an easy way to do this? Thanks.</P></BODY></HTML> Mon, 09 Jun 2014 17:19:02 GMT https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645068#M677819 2014-06-09T17:19:02Z Re: Determine Previous MonthEnd https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645069#M677820 <HTML><HEAD></HEAD><BODY><P>try:</P><P></P><P>=date(monthstart(today())-1)</P></BODY></HTML> Mon, 09 Jun 2014 17:25:45 GMT https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645069#M677820 2014-06-09T17:25:45Z Re: Determine Previous MonthEnd https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645070#M677821 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=Monthend(MonthStart(today())-1)</P><P></P><P>Eduardo</P></BODY></HTML> Mon, 09 Jun 2014 17:26:00 GMT https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645070#M677821 eduardo_sommer 2014-06-09T17:26:00Z Re: Determine Previous MonthEnd https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645071#M677822 <HTML><HEAD></HEAD><BODY><P>monthend(today(),-1)</P></BODY></HTML> Mon, 09 Jun 2014 17:29:18 GMT https://community.qlik.com/t5/QlikView/Determine-Previous-MonthEnd/m-p/645071#M677822 Gysbert_Wassenaar 2014-06-09T17:29:18Z