Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Determine Previous MonthEnd

try:

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

3 Replies
Not applicable

Re: Determine Previous MonthEnd

try:

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

eduardo_sommer
Valued Contributor

Re: Determine Previous MonthEnd

Try this:

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

Eduardo

Re: Determine Previous MonthEnd

monthend(today(),-1)


talk is cheap, supply exceeds demand
Community Browser