@Anonymous
Yes, so Time is going to play a part of your formula in the comparison. You need to account for it in the formula.
Please consider changing your Formula to the following:
Filter('Training Events',
DateAdd(_firstDayInView, ThisItem.Value, Days) >= StartDate &&
DateAdd(
DateAdd(_firstDayInView, ThisItem.Value + 1, Days),
-1, Seconds
) <= StartDate
)
This will set your ending date/time to be one second before midnight on the calculated day.
In other words, if your date calculation gave you a date of July 19 then that calculation (which is used in both of your comparisons would not match an actual startDate.
Example. If you have a StartDate event of 7/19/2022 13:00:00
Then your Formula would be comparing the following (the DateAdd part of the formula has been replaced below with the actual value that DateAdd would return.
Filter('Training Events',
'7/19/2022 00:00:00' >= StartDate &&
'7/19/2022 00:00:00' <= StartDate
)
If we substitute in the actual StartDate example Value:
Filter('Training Events',
'7/19/2022 00:00:00' >= '7/19/2022 13:00:00' &&
'7/19/2022 00:00:00' <= '7/19/2022 13:00:00'
)
Then you can clearly see that it will *never* match!
So, using the formula at the top of this reply and substituting in the DateAdd calculations, the formula becomes:
Filter('Training Events',
'7/19/2022 00:00:00' >= StartDate &&
'7/19/2022 23:59:59' <= StartDate
)
And now putting in the StartDate example:
Filter('Training Events',
'7/19/2022 00:00:00' >= '7/19/2022 13:00:00' &&
'7/19/2022 23:59:59' <= '7/19/2022 13:00:00'
)
You can see that this WILL match.
