Set Analysis Prior Month

[sagaraperera]

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

[tresesco · Accepted solution]

Try this:

=MonthEnd(max(MARKETING_DATE),-1)

[sagaraperera]

Dear tresesco

Thanks Dear its work

sagara

[tresesco]

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.