If you really want to find those times on the first Sundays in October and March dynamically, you can as below
If(
!IsBlank(StartDate_DP.SelectedDate),
With(
{
_Mar:
LookUp(
Sort(
ForAll(
Sequence(31),
Date(
Year(StartDate_DP.SelectedDate),
3,
Value
) + Time(1, 0, 0)
),
Value,
SortOrder.Descending
),
Weekday(Value) = 1
).Value,
_Oct:
LookUp(
Sort(
ForAll(
Sequence(31),
Date(
Year(StartDate_DP.SelectedDate),
10,
Value
) + Time(2, 0, 0)
),
Value,
SortOrder.Descending
),
Weekday(Value) = 1
).Value,
_DateTime:
StartDate_DP.SelectedDate +
Time(
Value(HourValue1.Selected.Value),
Value(MinuteValue1.Selected.Value),
0
)
},
DateAdd(
_DateTime,
If(
_DateTime >= _Mar && _DateTime <= _Oct,
-60,
0,
TimeUnit.Minutes
)
)
)
)
However using two dates raises a lot of complications - what happens when one is outside the period and one inside ?
Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn
