NOW

Returns the SYSTEM date and time.

Syntax

= NOW()

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

= NOW()

The present system date and time, e.g. 1/28/2010 11:43:00 AM

= NOW().Hour

The current hours.

= NOW().AddYears(-25)

The date and time twenty five years ago.

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

The year twenty five years ago.

Reference

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