You can use an expression like the following to store all weekends of the current year in the collection weekendsForYear:
ClearCollect(
weekendsForYear,
With(
{ startDate: Date(Year(Today()), 1, 1), endDate: Date(Year(Today()) + 1, 1, 1) },
Filter(
ForAll(
Sequence(DateDiff(startDate, endDate, TimeUnit.Days) + 1, 0),
DateAdd(startDate, Value, TimeUnit.Days)
),
Weekday(Value, StartOfWeek.Monday) >= 6
)
)
)
If you want the weekends for the current month, you can use an expression like the one below:
ClearCollect(
weekendsForMonth,
With(
{ startDate: Date(Year(Today()), Month(Today()), 1), endDate: Date(Year(Today()), Month(Today()) + 1, 1) },
Filter(
ForAll(
Sequence(DateDiff(startDate, endDate, TimeUnit.Days), 0),
DateAdd(startDate, Value, TimeUnit.Days)
),
Weekday(Value, StartOfWeek.Monday) >= 6
)
)
)
Hope this helps!
