MS Access Now() Function

Return the computer system's current date and time:

SELECT CustomerName, Now() AS CurrentDateTime
FROM Customers;

Definition and Usage

The Now() function returns the current date and time based on the computer's system date and time.

Now()

None.

Works in:	From Access 2000