Alteryx Designer Discussions

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

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")

 

grazitti_sapna_0-1598423437864.png

Thanks.

 

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.

 

Venkatesh_Sampath_0-1598429064337.png

 

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.

Thanks.

Sapna Gupta
11 - Bolide

Hi @Venkatesh_Sampath 

 

I would use a Multi-Field tool,

PaulFound_1-1598444334784.png

This will allow you to change the type.

 

PaulFound_0-1598444315657.png

PaulFound_2-1598444383474.png

 

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.

Labels