Change date format

[SH_94]

HI community,

May i know how can i change the format below to YearMonth in number?

Input 

May 2022

Sep 2022

Output

202205

202209

Many thanks 

[Qiu]

@SH_94 
The straightforward way to use 2 DateTime tools.

[grazitti_sapna · Accepted solution]

@SH_94, Another way of doing this using formula tool:

[ShankerV]

Hi @SH_94 

This can be achieved with the help of Datetime function.

Below link will help to get more insight on the datetime function.

https://help.alteryx.com/11.7/Reference/DateTimeFunctions.htm

https://help.alteryx.com/20223/designer/datetime-functions

Many thanks

Shanker V

[Felipe_Ribeir0]

Hi @SH_94 

One way of doing this, first use the datetimeparse formula to convert your date to the default date format that Alteryx understand (YYYY-MM-DD), and then convert this date to the format that you need.