ENDOFCURRENTMONTH

Returns the end date of the current month treating the system date as current date. The time returned is 11:59:59 PM.

Syntax

= ENDOFCURRENTMONTH()

Parameters

None

Return Type

DateTime. The function returns a Microsoft .NET DateTime object.  Any properties or member functions of the DateTime object can also be accessed or used in formulas.

Examples

Example

Returns

= ENDOFCURRENTMONTH()

If SYSTEM date is 1/28/2010: 1/31/2010 11:59:59 PM

= ENDOFCURRENTMONTH().Month

The current month.

= ENDOFCURRENTMONTH().AddDays(1)

The start date of the next month.

= ENDOFCURRENTMONTH().AddDays(1).Month

The next month.

Reference

http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx