Forum Discussion
Solved
dynamic date filter
Hi all, I have a query which has a date column, which has date from 2000.01.01 to 2099.12.31. I want to filter the date from 2016.01.01 till now. I therefore write in the M code as = Table.S...
Hi @Qianru221,
It seems that you are looking for this function Date.AddDays.
You could try to this formula below.
Date.AddDays (Date.From (DateTime.LocalNow ()) , 21)
For reference, you could have a good look at this similar thread.
Best Regards,
Dale
Hi @Qianru221,
It seems that you are looking for this function Date.AddDays.
You could try to this formula below.
Date.AddDays (Date.From (DateTime.LocalNow ()) , 21)
For reference, you could have a good look at this similar thread.
Best Regards,
Dale