Forum Discussion
Solved
Date.IsInNWeeks
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.
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)
1 Reply
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)