compBetween()

calculates the base, variable or cash compensation of a person over a specified period of time including all jobs the person has held compbetween() returns the compbetween calculation excluding data from primary syntax basecompbetween calculates the base compensation of a person over a specific time period, including internal transfers and moves basecompbetween( startdate date, enddate date, multiplier bigdecimal) startdate the start date of the checked time period enddate the end date of the checked time period multiplier optional multiplier defaults to 1 0 return type comp docid\ h 73ylw2ustscc tjerlf code sample result basecompbetween('2017 07 01', '2022 08 01", 1 0) returns the base comp of a person between january 7th, 2017 and january 8th, 2022 variablecompbetween calculates the variable compensation of a person over a specific time period, including internal transfers and moves variablecompbetween( startdate date, enddate date, multiplier bigdecimal) startdate the start date of the checked time period enddate the end date of the checked time period multiplier optional multiplier defaults to 1 0 return type comp docid\ h 73ylw2ustscc tjerlf code sample result variablecompbetween('2017 07 01', '2022 08 01", 2 5) returns the variable comp of a person between january 7th, 2017 and january 8th, 2022 and multiplies the value by 2 5 cashcompbetween returns the base + variable compensation of a person over a specific time period, including internal transfers and moves cashcompbetween( startdate date, enddate date, multiplier bigdecimal) startdate the start date of the checked time period enddate the end date of the checked time period multiplier optional multiplier defaults to 1 0 return type comp docid\ h 73ylw2ustscc tjerlf code sample result cashcompbetween('2017 07 01', '2022 08 01", 1 0) returns the base + variable comp of a person between january 7th, 2017 and january 8th, 2022