STARTOFCURRENTMONTH

Returns the start date of the current month treating the system date as current date. The time returned is 12:00 AM.

Syntax

= STARTOFCURRENTMONTH()

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
= STARTOFCURRENTMONTH()	If SYSTEM date is 1/28/2010: 1/1/2010 12:00:00 AM.
= STARTOFCURRENTMONTH().Day	The day for the start of current month.
= STARTOFCURRENTMONTH().AddDays(-1)	The end date of the previous month.
= STARTOFCURRENTMONTH().AddDays(-1).Month	The value of previous month.

Reference

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