How can I use Ms Access Date/Time Extended data type

Question

Ms Access documentation suggests there is a data type called "Date/Time Extended" which:

The Date/Time Extended data type stores date and time information and is similar to the Date/Time data type, but it provides a larger date range, a higher fractional precision, and compatibility with the SQL Server datetime2 date type.

However I cannot select this as the option is not in the table design Data Type drop/down list.

My version is Microsoft Access for Microsoft 365 (16.0.12827.20328) 64-Bit.

How can I use the "Date/Time Extended" data type?

user_7296893 · Answer

As far as I can tell, Date/Time Extended is not yet available in the latest release builds.

The documentation seems to be ahead of the actual release.

If you need it regardless, go to the Account page, and sign up for Office Insider, the beta channel, then click update options, and Update Now.

After that, it's in the dropdown for field types. Note that using it will break compatibility with previous versions of Office.

I can currently use the Date/Time Extended data type, and am on version 16.0.13012.20000 (latest beta channel).

Note that I strongly recommend on refraining from using this type for other purposes than testing until it's in a release version and you're 100% sure everyone using the database you intend to use it in has updated to a version that allows it.

user_9439330 · Answer

Seems it was released in May see Office Insider Monthly (Targeted) v2005 build 12827.20210 - May 21.

But you have to enable it in Options first.

As of today it should be availible on all channels except Semi-Annual Enterprise Channel.

To get your general release number (starts with 200X), check Word for Office Version.

How can I use Ms Access Date/Time Extended data type

2 Answers