Dat Time (extended Version) | About

: Currently, this data type is only available in Microsoft 365 and Access 2021 .

: This extended type covers a much wider range of years than the standard date type. About Dat Time (Extended Version)

: Open your table in Design View and select "Date/Time Extended" from the Data Type drop-down menu. : Currently, this data type is only available

: If you are linking to an external SQL Server database, go to File > Options > Current Database and check the box for "Support Date Time Extended (DateTime2) Data Type for Linked/Imported Tables" . Using the Date/Time Extended data type - Microsoft Support : If you are linking to an external

: Using this data type marks your database as a newer version, meaning it cannot be opened by older versions of Access (e.g., Access 2016 or 2019).

The data type is a modernized storage format in Microsoft Access, designed to improve compatibility with external databases and provide higher precision for time-sensitive records. Key Features