Thank you, both of you. It is working fine now!!!!!
"Ursus" <ursus.kirk@[EMAIL PROTECTED]
> wrote in message
news:48639e98$0$29783$dbd41001@[EMAIL PROTECTED]
>
> "Bill" <bbcollins@[EMAIL PROTECTED]
> schreef in bericht
> news:bbcollins-0CAF61.07374326062008@[EMAIL PROTECTED]
>> 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"
>
> Set the result as UNSTORED to keep the display updated all the time.
> Drawbacks to this: Can't relate to the unstored field, searchiong on the
> field not as fast because it is un-indexed. Further drawback: field
> doesn't get update on-the-fly. If the date changes while the file is
open,
> the change won't be reflected untill the database is closed and opened
> again (or updated through a scriptstep)
>
> Keep well, Ursus
>
|
