Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Determine Previous MonthEnd

Hi,

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.

1 Solution

Accepted Solutions
Not applicable
Author

try:

=date(monthstart(today())-1)

View solution in original post

3 Replies
Not applicable
Author

try:

=date(monthstart(today())-1)

eduardo_sommer
Partner - Specialist
Partner - Specialist

Try this:

=Monthend(MonthStart(today())-1)

Eduardo

Gysbert_Wassenaar

monthend(today(),-1)


talk is cheap, supply exceeds demand