cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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

SOLVED
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.