Extracting date from source source.name text

[Justas4478]

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 only latest file from the list.
For from this list latest file is 'REPORT spsf We-240324.xlsx' , if possible I would like it to always choose latest file available since list would be getting updated weekly.

If it is not possible then to allow files in certain date range. For example files from 01/04/2024 - 31/03/2025

Anyone know how I could do that?

Thanks

[tharunkumarRTK · Accepted solution]

@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

[Justas4478]

@tharunkumarRTK It is working thank you.