About Dat Time (extended Version) Apr 2026

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

: It supports a higher fractional precision for seconds, making it ideal for records that require extreme accuracy. About Dat Time (Extended Version)

: 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 : Currently, this data type is only available

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 Using the Date/Time Extended data type - Microsoft

: It is specifically designed to align with the SQL Server datetime2 data type. This ensures that when you link or import Access data to SQL Server, the fields map consistently without loss of data or formatting. Compatibility & Requirements