Forum Discussion

shuhn1229's avatar
shuhn1229
Icon for Resolver I rankResolver I
2 years ago
Solved

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...
Need Help
  • shuhn1229's avatar
    shuhn1229
    2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    shuhn1229
    Icon for Resolver I rankResolver I
    2 years ago

    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's avatar
      shuhn1229
      Icon for Resolver I rankResolver I
      2 years ago

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