Convert date time format to date

[troy_mech]

 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 @troy_mech , try this.

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

Thanks.

[troy_mech · 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]

@troy_mech , 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 @troy_mech 

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.

[DataMeister]

Paul: This is like a formula posted by Joe Mako elsewhere, which takes the DateTime and just converts it into a String that doesn't show the time--that's not a change in datatype from DateTime to Date. The problem is that Alteryx developers are not listening to users; we need one tool where we can specify basic date handling functions--it's not rocket science, just lack of focus.

Another pet peeve is that folks are saying "format" when they mean "datatype" and vice versa.

[Sereshan]

You can use a select tool to remove the time, by just changing the data type from DateTime to Date only

[KenAtHubbell]

You can manage the data type conversion in a formula by creating a new field that is a date and setting it equal to the field having the datetime value.  Same as using a SELECT tool but cleaner; especially since you can stack the formulas into the same tool.