Outputting AlteryX dates without the default time stamp of 00:00:00

[gundam_pilot]

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

[MarqueeCrew · Accepted solution]

@gundam_pilot,

Options:

1. create a new field or use a select.
   1. Left([Date_Field]), 10)
   2. Select, change to DATE instead of DATE/TIME

Cheers,

Mark

[Seth]

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