Date time tool to configure for multiple column

[Avishek1]

Dear Expert,

I have a requirement to change the date time to a specific format for multiple column, I am able to achieve this using date time tool however I have to add every time a data time column for individual column, is there a way we can configure it to apply for multiple column.

[Luke_C]

Hi @Avishek1 

You could use a multi field formula tool and a datetimeparse function for this. See attached example. 

More info on datetime functions: https://help.alteryx.com/current/designer/datetime-functions

[tansh0099]

Hi Luke,

it does not work when the input file is csv format. can you help me with an alternative in this scenario?

Thanks,

Tanushree 

[Luke_C]

@tansh0099 Can you be more specific? What's not working?