Forum Discussion
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...
Date.ToText(Date.From(DateTime.LocalNow()),[Format="ddMMMyyyy"])
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"])