community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

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

Highlighted

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

Alteryx Certified Partner
Alteryx Certified Partner

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteoroid

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

Labels