Renaming Columns with Dates as MMMM/YYYY

[programsam]

Looking to rename columns with dates in them as the MonthName and Year only using PQ. Not every column has a date so it would have to parse the list of column headers, find the one's with dates (all the first day of the month - '1/1/2023', '2/1/2023', etc.). The best I've done thus far has returned the month name but it does not display the year, it only shows the formatting for the year ("YYYY").

For clarity, the columns look like this.

What I'm wanting is: "July 2022"

What I'm getting using the code below is "July YYYY"

= Table.TransformColumnNames((#"Renamed Columns1"),each try Date.FromText(Table.ColumnNames((#"Renamed Columns1"){n}), otherwise _))

 

[RoryA]

You need to use yyyy not YYYY in the format code (which isn't in the M code you posted).

 

[programsam]

You need to use yyyy not YYYY in the format code (which isn't in the M code you posted).

OMG, apologize for that... copied the wrong (and incorrect) code. This is what I came up with and changing the "YYYY" to "yyyy" fixed the issue. Thank you!

= Table.TransformColumnNames(#"Promoted Headers", each try Date.ToText(Date.From(_),"MMMM/yyyy") otherwise _)