Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.
Returns a Variant (Date) specifying the current date and time according your computer’s system date and time.
|SELECT Now() AS Expr1 FROM ProductSales GROUP BY Now();||Returns the current system “Date and Time” in the default system Time format and displays in the column Expr1.|
|SELECT Now() AS CurrentDateandTime FROM ProductSales GROUP BY Now();||Returns the current system “Date and Time” in the default system Time format and displays in the column CurrentDateandTime.|
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 Now function to return the current system date and time.
Today = Now ' Assign current system date and time.
This information was compiled using information courtesy of © Microsoft 2020. All rights reserved.