laptop and a wrench

Bogue

When adding a table to the project database, the time value of 00:00 is not recognized. This is specific to the utilization of military time for the date parameter within the standalone table in ArcGIS Pro.

Dernière publication: May 30, 2018 ArcGIS Pro
Numéro d’ID de bogue BUG-000112240
EnvoiMarch 8, 2018
Dernière modificationJune 5, 2024
S’applique àArcGIS Pro
Version trouvée2.1.2
Système d’exploitationWindows OS
Version du système d’exploitationN/A
StatutKnown Limit

Informations supplémentaires

1. The .csv provided stored the date field as text, which is not best practice. A date field is preferred. 2. We format time based on the machine locale settings,. To change to a 24 hour clock, you need to use the short time format HH:mm and long time format HH:mm:ss 3. The blank value for your second value is an unfortunate limitation of Excel and Pro: Excel does not actually support MM/dd/yyy HH:mm:ss. You have to store the date and time values independently. In order to enable time for a layer, the datetime has to be in one field. If you add a time field only, it imports correctly, but Pro won't recognize just the time field as a valid field to enable time on a layer. 4. "Midnight" is handled by Microsoft in this case. Midnight is truncated because the assumption is 5/22/2018 12:00:00 AM = 5/22/2018 There is a better work around for your needs (in terms of seeing the right value in the table), but it only works for editable tables (not .csv): 1. Open the "Convert Time Field" tool 2. Fill in the parameters as desired 3. The output time field would be MM/dd/yyyy HH:mm:ss This field is text-only and will not be recognized as a time field, so if you need the layer to be time enabled, you will still have to use the DATE field if you want to interact with the time slider. The documentation can be found here: http://pro.arcgis.com/en/pro-app/help/mapping/time/supported-field-formats.htm

Solution de contournement

Use the standard 12-hour clock time format 12:00 a.m.

Étapes pour reproduire

ID de bogue: BUG-000112240

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement