Alteryx Designer Discussions

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

Convert date time format to date

8 - Asteroid

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

Alteryx Partner
Alteryx Partner

Hi @Venkatesh_Sampath , try this.


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





Sapna Gupta
8 - Asteroid

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.




Alteryx Partner
Alteryx Partner

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


Sapna Gupta
11 - Bolide

Hi @Venkatesh_Sampath 


I would use a Multi-Field tool,


This will allow you to change the type.





6 - Meteoroid

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

17 - Castor

Hi @Likness ,


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