How to include time in the Date Time Parse formulae
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Data_Alter
If I understand correctly, you need to change the output from String to Date format.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂 @Data_Alter
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂
