Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=MonthEnd(max(MARKETING_DATE),-1)
Dear tresesco
Thanks Dear its work
sagara
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.