Convert Date to String

[shuhn1229]

Hi all,

Pretty basic question. I'm trying to filter out all files that do not contain today's date in the file name. For this I have: 

Table.SelectRows(#"Renamed Columns1", each Text.Contains([Source.Name], "DATE"))

I am trying to replace "DATE" with Date.toFrom(DateTime.LocalNow()), so that this can be dynamic, but this throws a conversion error. Can anyone help with this?

Thanks!

[Daryl-Lynch-Bzy]

Hi @shuhn1229 - you need to consider one of the following to convert Date/DateTime to Text:

Date.ToText - PowerQuery M | Microsoft Learn
DateTime.FromText - PowerQuery M | Microsoft Learn
Text.From - PowerQuery M | Microsoft Learn

The second is probably better as you can define the format for the Datetime straight to DD-MM-YYYY (for example) without using Date.From step.

Here is good resource that list the date formats options:

Date Formatting in Power Query - Master 18 Custom Formats (gorilla.bi)

[shuhn1229]

Hi thanks, this is great. I used Text.From(DateTime.Date( DateTime.LocalNow() )) and recieved the value 11/03/23, which is great. I hate to bug but unfortunately / cannot be used in file names. How would I got about dropping them?

[shuhn1229 · Accepted solution]

Date.ToText(Date.From(DateTime.LocalNow()),[Format="ddMMMyyyy"])