Converting DD.MM.YY into a date format

[tom05]

I have a date format from a Excel input as DD.MM.YY however I am unable to tell Alteryx to change this date format to something else as it appears not to be recognised as a Date type.

My ultimate goal here is to convert the DD.MM.YY input to a recognized date format and then output to a new column which only tells me the MONTH YYYY.

For example:

01.06.2020 converted to June 2020

Thank you in advance.

[Aaron_Harter · Accepted solution]

Hi @tom05, 

Check out the DateTimeParse & DateTimeFormat expressions in the Formula tool:

[ArtApa · Accepted solution]

Hi @tom05 - You can also use the DateTime tool. You will need two of them, one to convert String to DateTime and one for DateTime to String. Please have a look at Example and you will quickly learn the tool:

[Qiu]

Hi, @tom05 
@ArtApa @Aaron_Harter  they have given the great answers.
Just to add, the Alteryx help is of great help, and for this case, you can check
https://help.alteryx.com/current/designer/datetime-functions

It gives the identifiers you need for almost all possible situations.

[grazitti_sapna]

Hi @tom05 , here is the solution to the problem.

Use formula tool with the given formula replacing the column Field1 with your column.

Datetimeformat(DateTimeParse([Field1],"%d.%m.%Y"),"%B %Y")

One thing you should remember is that it will always give you result in V_String as this is a custom format and alteryx only support yyyy-mm-dd format as date format.

Thanks.