Returns the SYSTEM date. The time returned is 12:00:00 AM.
= TODAY()
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 |
= 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. |
http://msdn.microsoft.com/en-us/library/system.datetime_members(VS.71).aspx