by Bill <bbcollins@[EMAIL PROTECTED]
>
Jun 26, 2008 at 07:37 AM
In article <cvmdnV_Epqta7v7VnZ2dnUVZ_v7inZ2d@[EMAIL PROTECTED]
>,
"Stephen Larivee" <lariveesl@[EMAIL PROTECTED]
> wrote:
> I have a date field called DATEOFHIRE. I would like to create a
calculated
> field that would show the time elapsed since that date. The number
could be
> a decimal and would be auto calculated by taking the date of hire and
> subtracting it from the current date and would auto update as each day
goes
> by.
>
> I am using FMP 8.5 and Windows XP.
>
> Thanks.
Calc field, call it DaysEmployed = Get(CurrentDate) - DateOfHire
This will return the number of days.
--
Bill Collins
For email, change "fake" to "earthlink"