Monday, June 27, 2022

Time Function [MS]

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 MyTime
MyTime = Time ' Return current system time.

Choose the right date function

No comments:

Post a Comment

Search This Blog

Why can't I open my file in Word on a mobile device? [MS]

Why can't I open my file in Word on a mobile device? Word for iPad ...