Forum Discussion
Date from text issue
Hey Guys, I have a set of data for training and I reach the point where I pivot the data properly yet, when I try to change the data type from text to date format (by changing type or using the ...
Date.From(Text.Combine(Splitter.SplitTextByAnyDelimiter({"st ","nd ","rd ","th "})([Attribute]),"-"))
Worked like magic
don't wanna bother, but can u tell me what was I doing wrong and how u wrote this formula, I'm a newbie in M
text with "st ","nd ","rd ","th " can not be recognized as a date, so you must replace them with "-".