Converting multiple date fields (including string types) to a YYYYMMDD date format

[jakemiroquai]

Hi there!
I have been doing some data cleaning on an excel file and I have been using the DateTime tool to change multiple Date fields into a YYYYMMDD format but I was wondering if it was possible to change multiple fields including those that are V_String type fields but are still resembling a YYYY-MM-DD format into YYYYMMDD date type format? I was thinking there has to be a better way of doing this instead of having like 10 DateTime tools, and having to select the relevant + newly generated columns after.
I am still very new to Alteryx and any help would be appreciated. If anyone could share some material on hopefully looking for my answers there, that would be great too. Cheers

[Peachyco]

You can use the Multi-Field Formula Tool for this.

Note that in the below configuration, we have to "Select All Types of Fields" because you have indicated that you need to target a mix of Date and String fields:

 

The data you see in the screenshot above is my sample input. At the end of the workflow, you get this:

Oh, but if you want to retain the old columns and create new ones, you have to tick "Copy Output Fields and Add", like so:

 

[jakemiroquai]

This actualy worked! Thank you so much!!