Hi,
Created a user based report to collect all the vacation days including date and numbers.
Used below taxt code to collect all days in timeoff.
displayname=Vacation Days in 2022 (Working Days Only)
listdelimiter=<br>
listmethod=nested(reservedTimes).lists
textmode=true
type=iterate
valueexpression=IF({endDate}>$$TODAYey,"",IF({endDate}>$$TODAYby,SUM(ROUND(WEEKDAYDIFF({startDate},{endDate})),0),""))
valueformat=HTML
Appreciate your suggestion in this regard.
Best regards,
Kundan.