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: 
sagaraperera
Creator
Creator

Set Analysis Prior Month

Dear All

I want to get prior month max date using input box and i already use following expression

 

=date(AddMonths(max(MARKETING_DATE),-1))

then i select apr 2019 and come to result 30 mar 2019 but it should be 31 mar2019

please help

 

sagara

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try this:

=MonthEnd(max(MARKETING_DATE),-1)

View solution in original post

3 Replies
tresesco
MVP
MVP

Try this:

=MonthEnd(max(MARKETING_DATE),-1)

sagaraperera
Creator
Creator
Author

 

Dear tresesco

Thanks Dear its work

 

sagara

tresesco
MVP
MVP

Sagara,
If you get your question answered, please mark it as correct/answered and 'like' it to close the thread. This will help other community members.