Re: Calculating "days" in FileMaker Pro

Article View: comp.sys.mac.databases

Article #186

Back to comp.sys.mac.databases Previous Next

#186

From: Brian Schipper
Date: Thu, 13 Aug 1992 22:03

17 lines
1146 bytes

srussell@cie.uoregon.edu (Steven Russell) writes:

>I am trying to create a calculated field in FileMaker Pro that will
>return the number of days since a date located in another field.  For
>example, if today is the 13th of August, I want to know how many days
>have passed since (for example) June 27th, 1991.  Is there a simple
>way to do this?  The calculation functions don't seem to lend
>themselves well to this task, but I may not be using them properly. 
>Can anyone help me out with this?

Sure.  Make a calculation field that returns a number result, and make
the calculation "Today - <datefield>", where <datefield> is the name
of the field you are computing the number of days from.

Brian
-- 
Internet: skip@claris.com                 AppleLink: SCHIPPER1

Technical Details

Message-ID: <15009@claris.com>

Path: arc1-ca.pugleaf.net!sparky!uunet!sun-barr!apple!apple!claris!skip

References: <1992Aug13.180842.26281@nntp.uoregon.edu>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!sun-barr!apple!apple!claris!skip
From: skip@claris.com (Brian Schipper)
Newsgroups: comp.sys.mac.databases
Subject: Re: Calculating "days" in FileMaker Pro
Message-ID: <15009@claris.com>
Date: 13 Aug 92 22:03:15 GMT
References: <1992Aug13.180842.26281@nntp.uoregon.edu>
Organization: Claris Corporation, Santa Clara CA
Lines: 17

Reply to Parent Message