Subset List of Dates Returned by Orchestrator GetCalendarByID API

I am using the Get Calendar API to get the list of holidays that have been defined in an Orchestrator calendar. I have successfully extracted the calendar dates to a List. But now what I want to do is to extract only the dates in the list that fall into a specific date range. I am not an expert in VB/C#, so other than reading the list element by element (which I don’t want to do), I don’t know how to extract just the desired range of DateTimeOffset elements in the list.

I’ve got to believe there’s a reasonably easy way to do it… just can’t seem to figure it out. Any help would be greatly appreciated… thanks.

I hope it helps when you assign the list into a data table and then use the filter the data table activity.

Good luck!

Thank you for the idea, but I was hoping to avoid having to store the data someplace temporarily just to filter it… although I suppose going after the underlying Orchestrator calendar data and filtering it that way, similar to your idea, might be an alternative. Thanks, Berna!