TODAY

Returns the SYSTEM date. The time returned is 12:00:00 AM.

Syntax

= TODAY()

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

= TODAY()

The present system date with time as 12:00:00 AM. In this case 1/28/2010 12:00:00 AM

= TODAY().Day

The current day.

= TODAY().AddYears(-25)

The date twenty five years ago and time as 12:00 AM.

= TODAY().AddYears(-25).Year

The year twenty five years ago.

= TODAY().subtract(STARTOFCURRENTYEAR()).Days + 1

Number of days since the beginning of the year.

Reference

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