Quote:
Originally posted by Don Plumley
Will Julian dates help with the leap year problem?? (non-programming background)
|
Relative to the other employees, yes - Jdate should work. You'll always have the proper order. A person hired in 1980 will always have a higher sen# than a person hired in 1981, despite 1980 being a leap year. (2006073 - 1980XXX will always be greater than 200673 - 1981XXX) And two people hired in 1980 will always have the appropriate order as well.
Note: you cannot use the "Z-man J-date result" to show anything but order of seniority. You can't really divide that number by anything to get a 'years of service' or anything else. To do that, you'd have to split apart the Jdate into years and days, and do calculations based on those two separate numbers.
-Z