Forum Discussion
Justas4478
Post Prodigy
Post ProdigyExtracting date from source source.name text
Hello, I have folder with multiple files. names are consistent and numbers represent week ending date. For example 240324 is 24/03/2024. I was trying to extract date since I need to keep onl...
Justas4478
You can use the below code and create a custom column. (Paste the below code in custom column window and replace the [Data] with your column name.#date(Number.From("20" & Text.Range(Text.BetweenDelimiters([Data], "-","."),4,2) ), Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),2,2)) ,Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),0,2)))If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
tharunkumarRTK
Super User
Super UserJustas4478
You can use the below code and create a custom column. (Paste the below code in custom column window and replace the [Data] with your column name.
#date(Number.From("20" & Text.Range(Text.BetweenDelimiters([Data], "-","."),4,2) ), Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),2,2)) ,Number.From(Text.Range(Text.BetweenDelimiters([Data], "-","."),0,2)))
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Justas4478tharunkumarRTK It is working thank you.