how to get last date of most recent completed month

[mahitham]

Hi Experts,

Can any please help me to obtain last date of most recent completed month dynamically.

For example we are in April last date of most recent completed month Is 31/03/2019. How to get this value in field.

Thanks in advance.

[arulsettu]

try this in your set analysis

MonthEnd(date(Today())-1)

[mahitham]

hi @arulsettu 

Getting 30/04/2019 as output. But expected output is always need to show the  last date of last completed month I,e, 31/03/2019

[Pato1984 · Accepted solution]

Hello ,

You can use 

Addmonths(Monthend(max(your fielddate)),-1)