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...
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)
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)