How to include time in the Date Time Parse formulae

[Data_Alter]

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.

[mbarone]

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.  

[Qiu]

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

[atcodedog05 · Accepted solution]

Hi @Data_Alter 

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 😀👍

[atcodedog05]

Hi @Data_Alter 

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

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

Hope this helps 🙂

[atcodedog05]

Happy to help 🙂 @Data_Alter 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂