Applies ToAccess for Microsoft 365 Access 2024 Access 2021 Access 2019 Access 2016

Returns a Variant (Date) indicating the current system time.

Syntax

Time

Remarks

To set the system time, use the Time statement.

Query examples

Expression

Results

SELECT Time() AS Expr1 FROM ProductSales GROUP BY Time();

Returns the current system "Time" for in the system Time format and displays in the column Expr1.

SELECT Time() AS CurrentTime FROM ProductSales GROUP BY Time();

Returns the current system "Time" for in the system Time format and displays in the column CurrentTime.

VBA example

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the Time function to return the current system time.

Dim MyTimeMyTime = Time    ' Return current system time.

Choose the right date function

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.