Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to include time in the Date Time Parse formulae

Data_Alter
8 - Asteroid

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.

 

 

5 REPLIES 5
mbarone
16 - Nebula
16 - Nebula

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
21 - Polaris
21 - Polaris

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

Capture22.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @Data_Alter 

 

Hope this what you are looking for

Workflow:

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

atcodedog05_0-1607691047034.png

 

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
22 - Nova
22 - Nova

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
22 - Nova
22 - Nova

Happy to help 🙂 @Data_Alter 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels
Top Solution Authors