Forum Discussion
How to set a date range
Hi, I hope someone can help me to solve this. I want to set a date range since 2024-01-01 to current date. I tried with this code but it doesn´t work. = Table.SelectRows(ConjuntoDeDatosConFaseTem...
Anonymous,
Try replacing the code in red with this:
DateTime.LocalNow()
Use this formula
= List.Dates(#date(2024,1,1),Number.From(Date.From(DateTime.LocalNow())- #date(2024,1,1))+1,Duration.From(1))