On my Calendar list I have recurring events. I have a view that wants to filter on the [Start Time] of the event but that field isn't available in the filter options of a view. After some research I found that the work around is to create a calculated column with a formula of =[Start Time] and this should create a column that shows the start time of the recurrence and this field should be available in the view filter.
The column IS available in the view filter, however it is returning the series start date&time instead of the recurrence event.
So as an example I have a Recurring Event ("Event1") that recurring every Friday @ 10:30am starting 12/10/2010 and going forever.
I create a Standard view with Expanded Recurring Events and can see all the iterations of the this event, however where the "Start Time" for a particular recurrence shows 1/6/2017 10:30am the calculated column shows 12/10/2010 10:30am.
I have seen this referenced many places as the work around, so what am I doing incorrectly. Why is my calculated column showing the series start instead of the event start?