website logo
ChartHop documentation
Carrot reference
Release notes
Navigate through spaces
ChartHop documentation
Carrot reference
Release notes
⌘K
Getting started
Getting started with Carrot
Operator precedence
Filtering with Carrot
Data categories
Basic Org Information
Compensation
Job Changes
Permissions
Personal
Recruiting
Structure
Time off
Data types
Address
Boolean
Comp
Comp Band
Currency
Date
DateTime
DaysOff
Enum
EnumList
File
Group
Image
Job
List
Money
Name
Number
Null
Percent
Person
PersonList
Shares
StockGrant
String
TimeOff
User
Operators
+ (add)
- (subtract)
* (multiply)
/ (divide)
% (modulus)
&& (and)
|| (or)
if
: (match)
= (equals)
!= (not-equals)
! (not)
> (greater-than)
>= (greater-than-equals)
< (less-than)
<= (less-than-equals)
[ ](array)
. (dot)
? (ternary)
?: (elvis)
Functions
abs()
asOf()
boolean()
compHistory()
compBetween()
costBetween()
date()
day()
daysOffBetween()
diffYears()
diffMonths()
distance()
monthEnd()
formatMoney()
formatRound()
formatNumber()
formatPercent()
formatDate()
grantedShares()
length()
max()
mean()
money()
month()
min()
nextAnniversary()
number()
pluralize()
percent()
random()
round()
roundUp()
roundDown()
string()
subString()
stockPrice()
monthStart()
split()
vestValue()
vestShares()
year()
Aggregators
count{}
max{}
mean{}
min{}
sum{}
Docs powered by archbee 
2min

Dates

Fields related to job employment start/end dates, anniversaries, and tenure.

Fields

Field name

Function

Field code

Anniversary

Returns an Org member's work anniversary.

anniversary

Create Date

Returns the date the job was created.

createDate

End Date in Job

The date that the Person left the job.

endDateJob

End Date at Org

The date that the Person left the organization.

endDateOrg

Job Start Date

Returns the Start Date of a Job.

jobStartDate

Last Promotion

Returns the date when the most recent promotion occurred.

promotionDate

Start Date

For filled jobs, the date the Person started at the organization, or for open jobs, the planned target start date.

startDate

Start Date in Job

The date that the Person started in the job.

startDateJob

Start Date at Org

The date that the Person started at the organization.

startDateOrg

Planned Start Date

For open roles, the intended target start date of the job. The field still remains once the job is hired.

startDatePlanned

Tenure in Job

The time in months that the Person has filled the Job.

tenureJob

Tenure at Org

The time in months that the Person has worked at the organization.

tenureOrg

Last Title Change

Returns the date of the most recent title change for an Org member.

titleDate

Updated 11 Oct 2022
Did this page help you?
Yes
No
UP NEXT
Anniversary
Docs powered by archbee 
TABLE OF CONTENTS
Fields