Work with data types, formats, and categories

Note:

Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.

You can use ArcGIS for Microsoft 365 data types, formats, and categories to improve location data matching results. See Data and geocoding to learn more about geocoding.

The following sections contain information about setting up data for ArcGIS for Microsoft 365.

Use time formats

ArcGIS for Microsoft 365 supports the date and time formats listed in this section. If you use a format that is not listed, ArcGIS for Microsoft 365 attempts to match it to an equivalent format; for example, 30Dec1997 will display as 30 Dec 1997. If there is no equivalent format, ArcGIS for Microsoft 365 uses the default value: MM/DD/YYYY HH:MM: AM/PM (12/30/1997 6:00 PM).

ArcGIS for Microsoft 365 supports the following date-time formats:

Date-time formatExample

MM/DD/YYYY

12/30/1997

Month DD, YYYY

December 30, 1997

Day Month (short) YYYY

Tuesday, December 30, 1997

MM/DD/YYYY HH:MM AM/PM

12/30/1997 6:00 PM

MM/DD/YYYY HH:MM (24hr)

12/30/1997 18:00

MM/DD/YYYY HH:MM:SS AM/PM

12/30/1997 5:50:50 PM

MM/DD/YYYY HH:MM:SS (24hr)

12/30/1997 17:59:59

Month YYYY

December 1997

YYYY

1997

HH:MM:SS AM/PM

5:59:59

HH:MM:SS (24hr)

17:59:59

HH:MM AM/PM

5:59 PM

HH:MM (24hr)

17:59


In this topic
  1. Use time formats