In Access, the Now function returns the current date and time according your computer's system date and time.

The syntax for the Now function is:

Now ( )

The Now function returns a date and time that are stored internally as a double-precision number.

Examples

Now ()      returns such as '05/05/2005 11:24:41 PM'

VBA Code

Dim MyResult As Integer  MyResult = Now

Now the MyResult variable would contain the current system date and time.

SQL query

You can also use the Now function in a query.

SELECT Now() AS Expr1 FROM Orders