home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.sys.mac.databases
- Path: sparky!uunet!gumby!destroyer!ncar!niwot.scd.ucar.edu!charlesa
- From: charlesa@niwot.scd.ucar.edu (Charles Albrecht)
- Subject: Re: Calculating "days" in FileMaker Pro
- Message-ID: <1992Aug13.220604.19014@ncar.ucar.edu>
- Sender: news@ncar.ucar.edu (USENET Maintenance)
- Organization: Scientific Computing Divison/NCAR Boulder, CO
- References: <1992Aug13.180842.26281@nntp.uoregon.edu>
- Date: Thu, 13 Aug 1992 22:06:04 GMT
- Lines: 41
-
- In article <1992Aug13.180842.26281@nntp.uoregon.edu> 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?
- >
- >--
- >-Steven Russell
- >srussell@uoneuro.uoregon.edu
-
- The function you've probably written is: Today - FromDate
- ^^^^^ (Today is a FMPro function)
- If you define this as a number, FM Pro will beep at you and give you
- a stern warning that the function will return a value of type "date." If
- you indicate that you do want to define it as a number, FileMaker will
- gladly allow you to do it, and should give you what you're looking for.
-
- A WARNING HERE. If you have a large database, you will find that the Today
- function recalculates each time you restart the database (on a new day).
- A few years ago, I thought it would be nice to use the Today function to
- age financial accounts, but the time required to recalculate 2000 records
- convinced me not to.
-
-
- Good Luck,
-
-
- Charles
-
- ----
- Charles Albrecht "Nonsense, they only say you can't survive
- charlesa@ncar.ucar.edu The Fire Swamp because no one ever has."
- 303/497-1828 - Westley, The Dread Pirate Roberts
-
- NCAR - Scientific Computing Division * P.O. Box 3000 * Boulder, Colorado 80307
-
- The opinions you are about to have read are fictitious...
- ...any similarity to opinions living or dead is purely coincidental.
-