Is there a way to get all data in N weeks time from one column?
I have found Date.IsInNextNWeeks, however if I want the week after next (Next 2 weeks) I also get the next week. Which I don't want.
Filtering by the next N weeks then deleting all weeks up to N will be fine, but I'm not sure how to do it if its possible.
If anything needs clarifying please don't hesiate to ask, thanks in advance.
Go to Solution.
Your filter condition could be
Date.IsInNextNWeeks([DateCol], N) and not Date.IsInNextNWeeks([DateCol], N-1)
Alternatively, you could shift the date and check if it's in the next 1 week:
Date.IsInNextNWeeks(Date.AddWeeks([DateCol], N-1), 1)
View solution in original post
Find out who won the T-Shirt Design Challenge and the top 3 finalists.
Find out more about the March 2023 update.