Returns the start date of the previous quarter treating the system date as current date. The time returned is 12:00:00 AM.
= STARTOFLASTQUARTER()
None
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 |
= STARTOFLASTQUARTER() |
As SYSTEM date is 1/28/2010, 10/1/2009 12:00:00 AM |
= STARTOFLASTQUARTER().Month |
The month for the start of previous quarter. |
= STARTOFLASTQUARTER().AddMonths(-3) |
The start date of the quarter before previous quarter. |
= STARTOFLASTQUARTER().AddMonths(-3). Month |
The month for the start of the quarter before previous quarter. |
Reference
http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx