Convert date time format to date

[Venkatesh_Sampath]

 I have column with data type date format 2020-01-30 15:02:45, i need to convert this into 30/01/2020. 

[grazitti_sapna]

Hi @Venkatesh_Sampath , try this.

Formula- DateTimeFormat([Field1],"%d/%m/%Y")

Thanks.

[Venkatesh_Sampath · Accepted solution]

Thank you for your response. This is not working since my data type is DateTime but the screenshot you shared has the data type V_Wstring. Is there any other way to convert this format, please assist.

[grazitti_sapna]

@Venkatesh_Sampath , that will not be possible as the default date/time format in alteryx is yyyy-mm-dd and we are converting it to a custom format dd/mm/yyyy so that has to be in string format in order to reflect the result.

Thanks.

[PaulFound]

Hi @Venkatesh_Sampath 

I would use a Multi-Field tool,

This will allow you to change the type.

[Likness]

The Muti-Field Formula works well. The only difference from the visual above is Changing the Output Type to Date to solve original question.

[atcodedog05]

Hi @Likness ,

%d/%m/%Y is not a alteryx accepted date fromat.