Convert Seniority Dates to Numbers
EMS42 Users: You can add the employee's Seniority (Start) Date to the employee grid on the Shifts to be Filled page, reducing the need for the Seniority hours calculation.
If Seniority is in Date format and you want to convert that date to a number for use in the Seniority field follow the steps below:
1. Convert StartDate to number
(Excel has a DateValue function)
(Feb 09/2001 = 36931)
2. Subtract that number from 100000
(to reverse the order so that earlier dates have higher seniority)
(100000 - 36931 = 63069)
3. 63069 becomes Seniority Hours