Date to date time conversion

[Avishek1]

Expert,

Please help me with the conversion from date to date time

input- DD-MMM-YYYY

Output - YYYY-MM-DD HH:MM:SS

[Emil_Kos]

Hi @Avishek1,

I prepared a workflow for you:

I am assuming a format that you had on mind is similar to this:

22-Jan-2021

[echuong1]

Another option is to use the Datetime tool to convert the date into the proper alteryx recognized format, and then a Select to change the date to a datetime.

This may be a little easier to understand for a new user 🙂