I have a data set with over 10 date columns that are string formatted like "20240801". I want to use REGEX to format and convert the column to a date field and format it as "8/1/2024". I don't want to use the DateTime Convert tool and formula tools for each column since it will make my workflow very cumbersome. Is there a way to use a regex tool for each column instead without having to use additional parse and formula tools?
Solved! Go to Solution.
The 'Change Output Type to' in the Multi-Field Formula configuration - shown in the screenshot of my second response above!
@DataNath Got it! Sorry for the constant questions! Thank you so much!!!!
No problem at all @RCern - always happy to help! :)