Access: Now Function

In Access, the Now function returns the current system date and time.

The syntax for the Now function is:

Now ()

For example:

Now() would return a value such as '22/11/2003 10:42:58 PM'

VBA Code

The Now function can be used in VBA code. For example:

Dim LValue As String

LValue = Now

In this example, the variable called LValue would now contain the current system date and time.

You can also use the Now function in a query.