Returns the start date of the current year treating the system date as current date. The time returned is 12:00:00 AM.
= STARTOFCURRENTYEAR()
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 |
|
= STARTOFCURRENTYEAR() |
As SYSTEM date is 1/28/2010, 1/1/2010 12:00:00 AM |
|
= STARTOFCURRENTYEAR().Year |
The current year. |
|
= STARTOFCURRENTYEAR().AddDays(-1) |
The end date of previous year. |
|
= STARTOFCURRENTYEAR().AddDays(-1).year |
The previous year. |
http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx