Change date format "yyyymmdd" without creating a new column

[Rayyl]

Hello, 

is there a specific way to change the date format (for example column "I" - Delivery Date" in the Excel in my attachments) so that i can then use it for formulas? Before that i get the message that this column does not represent a valid date format. The important thing here is that i can't create a new column and the DateTime tool would therefore not be usable. Thanks in advance guys!

Best regards,

Christian

[Peachyco · Accepted solution]

Here's how I would do this:

1.  (Optional) Use the Select Tool to force the [Delivery Date] into the "String" data type. This is because the format "YYYYMMDD" is purely numerical and might be interpreted by Alteryx as an integer.
2. Use the Formula Tool with the DateTimeParse formula to change the format of [Delivery Date] to the date format that Alteryx recognizes and uses.
3. Use the Select Tool to change the type of [Delivery Date] from "String" to "Date".

[binuacs]

@Rayyl Another option with Multi-Field tool

[FinnCharlton]

Hi @Rayyl , you can also do it with the multi-field formula tool:

[Rayyl]

Thanks guys!