Convert text field to date format
I need to convert a numeric text formatted field (for example 04092022) into a date formatted field (04/09/2022).
All of the existing conversion actions will not do the conversion properly. The only solution at this point is a series of parsing the data into Month/Day/Year variables and then joining them back up with the slashes. Which isn't hard, but seems more work than is necessary.