Hi all,
I've got a time exception setup with dates in it that is easy enough to maintain. I've also been able to use the variable GetNextTimeException to get the next datetime exception in my collection. However, I can only get the next datetime exception from the current date. For example, if I have July 4th in my collection and I run the formula {DATE(GetNextTimeException|<collection ID>|)} on July 1st, I'll get July 4th back. However, if I run the same formula after July 4th, I'll get the next date in the collection. Is there a way to pass a date to the GetNextTimeException variable so that I can get the next datetime exception from a given date. I was hoping for something like {DATE(GetNextTimeException|<datetime>|7/1/2023)} which will always return 7/4/2023 regardless of what day I run it on.