Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date Time Format with REGEX

RCern
8 - Asteroid

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?

12 REPLIES 12
DataNath
17 - Castor
17 - Castor

The 'Change Output Type to' in the Multi-Field Formula configuration - shown in the screenshot of my second response above!

RCern
8 - Asteroid

@DataNath Got it!  Sorry for the constant questions!  Thank you so much!!!!

DataNath
17 - Castor
17 - Castor

No problem at all @RCern - always happy to help! :)

Labels
Top Solution Authors