This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.