Date Transformation

[RajatRehria]

Hi guys,

I have dates like below format:

Month

07/01/2022

08/01/2022

09/01/2022

10/01/2022

11/01/2022

12/01/2022

01/01/2023

Totals

and i want to convert this column like below using date formula, i tried the Date Time tool but that is not working, kindly help me with the formula for the desired output:

Month

July-2022

August-2022

September-2022

October-2022

November-2022

December-2022

January-2023

[ChrisTX · Accepted solution]

Guessing your input data type is string.  See attached workflow.

 

Chris

[MichelleMitchellLutz · Accepted solution]

I would use the Date Time Tool then a Formula tool for the desired output. 

 

[ShankerV · Accepted solution]

 Hi @RajatRehria 

One way of doing this.

DateTimeFormat(DateTimeParse([Month],"%m/%d/%y"),"%B-%Y")

Many thanks

Shanker V