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
Here's how I would do this:
-
(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.
-
Use the Formula Tool with the DateTimeParse formula to change the format of [Delivery Date] to the date format that Alteryx recognizes and uses.
-
Use the Select Tool to change the type of [Delivery Date] from "String" to "Date".
