Thank you both for your responses. Amy, this is one of those cases where I'm lucky to get the information let along get them to do extra work like that. :-)
Thanks! --- In [email protected], "Amy" <[EMAIL PROTECTED]> wrote: > > --- In [email protected], "Mark" <pusateri02@> wrote: > > > > I'm getting a list of employees where the "Hire Date" is one of the > > fields. I'd like to change that into length of service by way of > > yy/mm/dd. Can anyone help me with the math on this please? > > Where is this list coming from? If it is coming from a database, why > not just let the database calculate the difference in dates? The > databases I've worked with use the DateDiff function for this, but this > function name might be different in other databases. > > HTH; > > Amy >
