In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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