In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Change datetime value into just a date value

ozzy78910
6 - Meteoroid

Hi all

 

Im wondering if anyone knows how to change a datetime value to just a date?

 

An example of the current value is 2020-02-28 08:00:00 however i would just want to change it to 28/02/2020

 

The current format in alteryx of this cell is V_String

 

The column name im looking at is called 'DRS Customs Release Date'

 

Thanks

ozzy

2 REPLIES 2
PHinkel
7 - Meteor

Hi ozzy78910,

 

The DateTime tool will allow you to convert this V_String DateTime.


Then a Select Tool will allow you to change the variable type to Date.

 

Qiu
21 - Polaris
21 - Polaris

@ozzy78910 

Alteryx only allows date to be in yyyy-mm-dd so if you want 28/02/2020, it has to be a string.

0128-ozzy78910.PNG

Labels
Top Solution Authors