Outputting AlteryX dates without the default time stamp of 00:00:00
- 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
Hi AlteryX experts,
I have a date field of the standard AlteryX format, for example 2008-06-01 00:00:00. I would like to remove the time stamp at the end so that it becomes 2008-06-01 (and can be readily outputted to Excel to the format of 01/06/2008).
How could this be done efficiently without manipulation in Excel?
Thanks!
Gundam
Solved! Go to Solution.
- Labels:
- Date Time
- Output
- Preparation
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Options:
- create a new field or use a select.
- Left([Date_Field]), 10)
- Select, change to DATE instead of DATE/TIME
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I realize this was resolved awhile ago, and done very well. I'm clarifying it for future users, as it is a good solution.
Solution - Drop a Select tool before the final Output Data tool and in the date field change Type to "Date", and then change the Size from 19 to 10. This will remove the hh:mm:ss. This will create the format you are looking for in Excel.
I hope this helps
