Returns the end date of the current quarter treating the system date as current date. The time returned is 11:59:59 PM.
= ENDOFCURRENTQUARTER()
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 |
= ENDOFCURRENTQUARTER()- |
If SYSTEM date is 1/28/2010: 3/31/2010 11:59:59 PM |
= ENDOFCURRENTQUARTER().Month |
The month for the start of current quarter. |
= ENDOFCURRENTQUARTER().AddDays(1) |
The start date of next quarter. |
= ENDOFCURRENTQUARTER().Add Days(1).Month |
The month for the start of next quarter. |
http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx