Has anyone figured out how to report time off as reported by users?

Does anyone know how to chronologically sort the dates returned in a collection?

Thanks Robert, Where exactly do you type in the code? I went to Reports > Calendar > Edit Calendar Item, then the only options are tasks, projects, or issues. I've tried it in each, but have not seen the results that I expected. I just want to be able to overlay the time-off for everyone on my team. Seems like it shouldn't be this complicated. The list format is hard to use when you have a large team.

You can report on it, but currently there is no way to add it to the calendar. We have had a feature request open for this since March 2015. Adina ________________________________

Eric C. the text mode code I mentioned goes in a Report Columns (View), not a Calendar. Calendar Tasks, Projects, Issues only offer ways to filter the content shown on a Calendar. Notice that "Users" is not an option, where presumably we might access "reservedTimes" entries. Workfront will need to help us learn how to plot Time-off entries on a Calendar.

Would anyone happen to know how I can change the valueexpression to do a sum of the datediff? I'm looking to get the number of days and multiple by 8. I have a teammate looking for a report that will like keyed hours + nonWorkDays + ReserveTimes.

In case anyone was interested. I have created a valueexpression that will give you the hours for the time off for users. valueformat=HTML listdelimiter= textmode=true valueexpression=IF({endDate}<$$TODAYe+1w,"",DIV(WORKMINUTESDIFF({endDate},{startDate}),60)) type=iterate listmethod=nested(reservedTimes).lists displayname=Vacation Hours If you take a solid week off, this process will look at the user's schedule and not count days that are marked as off on the user's schedule. For example on our schedule, Memorial day is a day off for all. I marked the entire week off for vacation. This calculation returned back 32 hours instead of 40. Hope this helps. Now, I would like to get the schedule days off for this report. Haven't figured this out yet. Also, it still lists instead of summing the entire list. :-(

Nice text mode noodling, Michael: I am impressed! Thank you for sharing. Regards, Doug

Despite not being able to total the hours, this code reveals good stuff. Thanks. ps. I wonder if any text code is able to aggregate data in a collection?