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:
![](blob:https://community.alteryx.com/185ce244-60bc-4a39-8a17-c3dfeed75baa)
The select tool confirms is a String
![](blob:https://community.alteryx.com/f1dccf14-332e-426d-b80d-2c4a43a96ec9)
If we use the Auto Field as:
![](blob:https://community.alteryx.com/868a5680-6b55-4cf5-a8c9-5b9a88bb5fc4)
The result is still a String data type (2nd Select Tool)
![](blob:https://community.alteryx.com/f9761e6e-550a-46ba-8d3c-ac7b9daf308b)
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.