Carrot reference
Functions
findTimeOff()
returns time off over a period of time, either for one individual person or across the org any time off that overlaps part of the date range being queried will be returned syntax findtimeoff(from, until\[, person]) parameters true false 166,127false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type return type sequence docid\ jg4itlqwafzlparttfo67 < timeoff docid\ rahsihytvr1nskqtdfkja > examples findtimeoff(date, "+1m") count() returns the number of time off requests (including those pending and not approved) that are occurring in the next 30 days findtimeoff("2025 10 01", "2025 11 01") filter{status\ approved} count() returns the number of time off requests that have been approved that occur in the month of october findtimeoff("2025 10 01", "2025 11 01", person) filter{status\ approved} sum{days} returns the total number of days off for a particular person for time off overlapping the month of october findtimeoff("2025 01 01", "2026 01 01") filter{status\ approved and policy name "uk sick policy"} sum{days} returns the total number of days off taken for approved time off requests for the "uk sick policy" that overlap the calendar year 2025