Calculate contract length
I am trying to calculate the length of a contract using the start date and end date of the contract. I have a field for contract length (years) and a field for contract length (months). We do have ...
Forum Discussion
Yes, you got it.
To make it a bit clearer:
1) Academic Year contract: Aug - May (how many years appointed per term of contract 1,2,3,4,5,or 6)
2) Academic Semester contract: Jan - May (spring) or Aug - Dec (fall); term will always be 5 months
3) 12-Month contract: the annualization factor is 12 so the less than 1-year appointments (non-academic) can fit here
Hope this helps.
------------------------------
Jaclyn Schlipp
------------------------------
To make it a bit clearer:
1) Academic Year contract: Aug - May (how many years appointed per term of contract 1,2,3,4,5,or 6)
2) Academic Semester contract: Jan - May (spring) or Aug - Dec (fall); term will always be 5 months
3) 12-Month contract: the annualization factor is 12 so the less than 1-year appointments (non-academic) can fit here
Hope this helps.
------------------------------
Jaclyn Schlipp
------------------------------
I would recommend setting up a Formula Numeric Field and 1 would be equal to 1 year and less than 1 is a fraction of the year. Your formula would simply be
If ((Year([End Date])-Year([Start Date]))=0,(Month([End Date])-Month(Start Date]))/12.0,Year([End Date])-Year([Start Date]))
------------------------------
John Crosland
Software Developer
Inglett & Stubbs
Mableton GA
------------------------------
If ((Year([End Date])-Year([Start Date]))=0,(Month([End Date])-Month(Start Date]))/12.0,Year([End Date])-Year([Start Date]))
------------------------------
John Crosland
Software Developer
Inglett & Stubbs
Mableton GA
------------------------------
