With the increase number of JSON feeds and the need to properly define the data type for date and date/time fields. It would be useful to have the Auto Field tool detect common date and date/time formats from Strings and assign the Date, Date Time, or Time data type.
Given the following input data:
The select tool confirms is a String
If we use the Auto Field as:
The result is still a String data type (2nd Select Tool)
I would expect this to be Date Time.
One solution would be to create a formula and parse it, but this is not suitable for situations that the field names are unknown.
It would be much easier to have the work done by Auto Field.