Last Day of Current Month

[stephm923]

I need to create a formula that will give me the last day of the current month (ex. 2006-11-30)

 

[synapsevampire]

Try:

dateserial(year(currentdate),month(currentdate)+1,1)-1

-k

 

[bdreed35]

Here is one way to do it:

dateadd("m",1,minimum(monthtodate))-1

~Brian

 

[lbass]

Try:

dateserial(year(currentdate),month(currentdate)+1,1)-1

-LB

 

[stephm923]

Worked like a charm. Thanks!!