Now

Returns a date that represents the current date and time according to the setting of the computer’s system date and time.

Arguments

Now[( )]

Notes

The parentheses are otional only when you use Now in Access Basic. The Now function returns a Variant of VarType 7 (Date) containing a date and time that are stored internally as a double-precision number. This number represents a date and time from January 1, 100 through December 31, 9999, where January 1, 1900 is 2. Numbers to the left of the decimal point represent the date; numbers to the right represent the time.

Example

In this example, the Now function returns the current date as a Variant (VarType 7) containing a date. The Format function formats the date as a long date including the day and date.

Today = Now // Get current date and time.

MsgBox "Today is " & Format( Today, "dddd, mmmm dd, yyyy" ) & "."