Returns the start date of the quarter for the date passed to the function. The time returned is 12:00:00 AM.
= STARTOFQUARTER(valueDate)
|
valueDate |
A date time value whose start date of the quarter is to be determined. The value can contain DateTime as a string (e.g. “02/19/2009 14:30:30.3”, "2009-02-19 14:30:30.3", "19 Feb 2009 2:30:30.3 PM ", "Thu, 19 Feb 2009”) or as a DateTime object. |
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.
|
Example |
Returns |
|
= STARTOFQUARTER("02/19/2009") |
1/1/2009 12:00:00 AM |
|
= STARTOFQUARTER("02/19/2009").MONTH |
The month for the start of quarter for the given date. |
|
= STARTOFQUARTER("02/19/2009").ADDMONTHS(3) |
The start date of quarter next to the given date. |
|
= STARTOFQUARTER("02/19/2009").AddMonths(3).Month |
The month for the start of quarter next to the given date. |
http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx