View Single Post
Don Plumley Don Plumley is offline
Moderator
 
Don Plumley's Avatar
 
Join Date: Jun 2001
Location: Geyserville, CA
Posts: 6,921
Garage
I did a quick and dirty one in five minutes. It's in your inbox.

Legion - email me and I'll send you the sheet. Basically, I create a named value called "offset" by adding n years to today's date. Calculate years of service by subtracting the date of hire from the offset. Then use an IF statement to ask if the age is 60 or less. If true, value is 0, if false, value is -999. Then add the years of service to the result of the IF statement. That way, if the pilot is over 60, their years of service goes to a big negative number, but pilots under 60 have the years of service as normal. Sort on this figure.
__________________
Don Plumley
M235i
memories: 87 911, 96 993, 13 Cayenne

Last edited by Don Plumley; 03-14-2006 at 08:06 PM..
Old 03-14-2006, 08:01 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #23 (permalink)