How to include time in the Date Time Parse formulae

How can I include time using the Date time Parse formulae in the workflow attached.

I need to put this in an application hence I can't use separate Date time node we have in Alteryx , I need to do it using the Formulae node.

Thanks in advance for your help.

Date Time

Accepted answers

Hope this what you are looking for

Workflow:

DateTimeParse([Effective Date], "%d-%m-%Y %H:%M:%S")

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

If you check the help files page here: https://help.alteryx.com/2019.4/Reference/Functions.htm you'll find a lot of information that will help you do this.

@Data_Alter
If I understand correctly, you need to change the output from String to Date format.

Hope this what you are looking for

Workflow:

DateTimeParse([Effective Date], "%d-%m-%Y %H:%M:%S")

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

And here is a helpful resource with different Specifiers for parsing the date.

Hope this helps 🙂