STARTOFLASTYEAR

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

Syntax

= STARTOFLASTYEAR()

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
= STARTOFLASTYEAR()	As SYSTEM date is 1/28/2010, 1/1/2009 12:00:00 AM
= STARTOFLASTYEAR().Year	The previous year.
= STARTOFLASTYEAR().AddMonths(2)	The start date of end of 1^st quarter for last year.
= STARTOFLASTYEAR().AddYears(1).Year	The current year.

Reference

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