Hi All,

let
    Source = Csv.Document(File.Contents("\\company.com\dfs\data\WM\CR\Shared\CPM\20240419TESTFILE.csv"),[Delimiter=",", Columns=24, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    
    #"Changed Type"
I Have created a connection to a CSV file using the above code.

The issue I have is that a new source file is created daily and is named YYYYMMDDTESTFILE.

Can someone please tell me how I amend the code so that when I run the query, the source file name updates dynamically to todays date?

Many Thanks in advance