numerical value of addmonths()

[damien_burns]

Looks like the monthend() expression in the table below takes the numerical value for today(), is that expected behaviour?

:

[Saravanan_Desingh]

Try this.

AddMonths(MonthEnd(Today(),-1))

[damien_burns · Accepted solution]

I dont think addmonths will work but monthend on its own seems to

=num( floor( MonthEnd(Today(),-1) ) )