Date.IsInNWeeks

[TobyYoung1]

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.

[AlexisOlson · Accepted 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)