Date Time Language Help
- 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
Hello,
I am trying to get the attached date time formatted into Alteryx's native date time format using Date Time Parse, but I cannot figure our the format for the "language" in the formula.
Any insight here on the language structure would be appreciated!
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes i am writing the formula using Date Time Parse - but i am not sure what the language structure should look like with the attached picture. Attached is what i have currently and it's not showing as correct
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I attached my solution above - let me know if it works for your requirements. Otherwise if not, please post the sample data so we can work with it better and let us know what else would be needed. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
so your solution just snips the last part off - I would like it to be in actual Alteryx date time original format, so I would like to use the Date Time Parse formula. I have attached the excel for how the date time is coming in.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am confused by your note - Alteryx DateTime format is YYYY-MM-DD hh:mm:ss only. Is there another format you are expecting?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In your solution - the "T" is still present in the middle of the new date time output so its not in the correct format and i will not be able to manipulate the output after using that formula as if it is a date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
But my solution doesn't have the T?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
interesting - this is the output using your formula in my actual workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
use this formual
ToDateTime([Invoice Date])
this will help
