Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this in your set analysis
MonthEnd(date(Today())-1)
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
Hello ,
You can use
Addmonths(Monthend(max(your fielddate)),-1)