TEXT FORMAT TO DATE FORMAT AND EXTRACT YEAR AND MONTH

[anoomohan]

Dear all,

Please help me to extract month and year from below field, I tried changing using Locale - but getting error while doing so. 

[anoomohan]

I checked your file, its working perfect, but still I am getting error

[Ahmedx · Accepted solution]

you added extra squares [

[anoomohan]

Thanks! 

I am getting error - btw, i am sending this from UAE, do we need to change the "en-US"?

[Ahmedx]

pls try this

= "01-"& Text.Combine(
Splitter.SplitTextByCharacterTransition({"A".."Z", "a".."z","-"}, {"0".."9"})([Column1]))

[Ahmedx]

pls show the error

[anoomohan]

AFTER i entered ur first response - column changed as below 

[Ahmedx]

pls  try this

Date.FromText([Column1], [Format = "MMM-yy", Culture = "en-US"])