Change datetime value into just a date value

[ozzy78910]

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

[PHinkel]

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]

@ozzy78910 

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