Forum Discussion
Convert Date to String
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!
Date.ToText(Date.From(DateTime.LocalNow()),[Format="ddMMMyyyy"])
3 Replies
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 LearnThe 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)
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?
Date.ToText(Date.From(DateTime.LocalNow()),[Format="ddMMMyyyy"])
