idea Once a field is changed to a 'Date/Time' data type, you can't change it back to 'String' in ArcGIS Insights Ideas

Once a field is changed to a 'Date/Time' data type, you can't change it back to 'String'

SaraHedrick1 — Mon, 15 Aug 2022 14:27:24 GMT

I'm working with a large dataset, and I accidently changed a string field to 'Date/Time', and I can't change it back. I'm working in the browser version of ArcInsights, and it could be an error with my system.

Re: Once a field is changed to a 'Date/Time' data type, you can't change it back to 'String'

Scott_Aulen — Thu, 18 Aug 2022 22:24:30 GMT

@SaraHedrick1,

You have a couple of options in this scenario. Obviously, if you catch it right away, the undo tool works on data type changes but I'm assuming we're past that point 😀.

The best option then is to combine the time components back into a new String field using the CONCATENATE Function.

If using ArcGIS Insights Desktop, you could also use the Data Engineering workbook to change the field type.

Re: Once a field is changed to a 'Date/Time' data type, you can't change it back to 'String'

Rob_Hughes_32Alpha — Mon, 03 Apr 2023 20:50:55 GMT

This should be a feature, not a workaround you have to figure out yourself. Please fix it Esri.