Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Looks like the monthend() expression in the table below takes the numerical value for today(), is that expected behaviour?
:
I dont think addmonths will work but monthend on its own seems to
=num( floor( MonthEnd(Today(),-1) ) )
Try this.
AddMonths(MonthEnd(Today(),-1))
I dont think addmonths will work but monthend on its own seems to
=num( floor( MonthEnd(Today(),-1) ) )