Forum Discussion
Solved
Multiple date formats in column
Good day - my first post on the Forum! :)- I'm reading from an Excel file, and the format of the date column is either 2021/11/08, or March '22 (in this case, it can default to 2022/11/01). I su...
Leave everything, in a custom column put this. That's it.
= Date.From(if Text.Contains(Text.From([Live date]),"'") then "1"&Text.Replace([Live date],"'","") else [Live date])If you want to convert this column to a date, select column - Transform tab - Detect data type
1. your first statement -
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],1. do I paste it into the Applied step Source?
2. The next part - I assume that is the new calculated column - please explain the change?
Thankful
Leave everything, in a custom column put this. That's it.
= Date.From(if Text.Contains(Text.From([Live date]),"'") then "1"&Text.Replace([Live date],"'","") else [Live date])If you want to convert this column to a date, select column - Transform tab - Detect data type
Stunning - it works. Please may you explain what made it work?
Appreciate your assistance.