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.
Please let me know if there are other text fields that you would want a new formula that does this to handle.