COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Age Calculation

• Email
• Follow

```I have a FMP database that keeps track of driver education students.  I'm
not knowledgeable in FMP, but I can usually get it to do what I want.
Which one of these formulas would work best to calculate age based on birth
date and the system date or is there a better one?  I'm using the second one

Year(Today) - Year(Birthdate) - If(Today< Date(Month(Birthdate),
Day(Birthdate),Year(Today)),1,0)

Year(Status(CurrentDate)) - Year(Birthdate) - If(Status(CurrentDate)<
Date(Month(Birthdate), Day(Birthdate),Year(Status(CurrentDate))),1,0)

I'm also having trouble with the age not recalculating every day.  I'm using
FMP 4.1 and in the storage options I have the box  checked for "do not store
calculation results"  It should still recalculate every day shouldn't it?

```
 0
Reply tomr40 (1) 4/29/2004 2:15:56 AM

See related articles to this posting

```Your using the best of the two, infact, the Today function has been
removed from the most current version of FileMaker and has only hung
around so long for backwards compatability.

Although age calculations tend to be a bit tricky, I don't see any
reason yours isn't working properly. So I'm a little confused when you
say doesn't recalculate everyday.

Are there ages that are not updating correctly or were you used to the
Today function, which recalculated all the records everytime the
database was opened?

Michael Myett

Tom Ryan wrote:
> I have a FMP database that keeps track of driver education students.  I'm
> not knowledgeable in FMP, but I can usually get it to do what I want.
> Which one of these formulas would work best to calculate age based on birth
> date and the system date or is there a better one?  I'm using the second one
>
> Year(Today) - Year(Birthdate) - If(Today< Date(Month(Birthdate),
> Day(Birthdate),Year(Today)),1,0)
>
> Year(Status(CurrentDate)) - Year(Birthdate) - If(Status(CurrentDate)<
> Date(Month(Birthdate), Day(Birthdate),Year(Status(CurrentDate))),1,0)
>
> I'm also having trouble with the age not recalculating every day.  I'm using
> FMP 4.1 and in the storage options I have the box  checked for "do not store
> calculation results"  It should still recalculate every day shouldn't it?
>
```
 0

```The better calculation is the second one as previously mentioned ... works
with FM 7.

The only problem in calculating I can think of  is when the date of birth
has been formatted (e.g., April 4, 1988) ... it has given me problems in the
past.  Make sure the date of birthday is entered mm/dd/yyyy with NO
FORMATTING.

If you set the system clock ahead or back you can see the age change.
Obviously, the only time an age changes is when the birthdate of a student
crosses over the system date; otherwise, no change in a student's age will
occur.

--
Al Lawrance
ajlawrance@shaw.ca
http://www.members.shaw.ca/ajlawrance/

"Tom Ryan" <tomr40@surfbest.net> wrote in message
news:BCB5CF8C.13AEE%tomr40@surfbest.net...
> I have a FMP database that keeps track of driver education students.  I'm
> not knowledgeable in FMP, but I can usually get it to do what I want.
> Which one of these formulas would work best to calculate age based on
birth
> date and the system date or is there a better one?  I'm using the second
one
>
> Year(Today) - Year(Birthdate) - If(Today< Date(Month(Birthdate),
> Day(Birthdate),Year(Today)),1,0)
>
> Year(Status(CurrentDate)) - Year(Birthdate) - If(Status(CurrentDate)<
> Date(Month(Birthdate), Day(Birthdate),Year(Status(CurrentDate))),1,0)
>
> I'm also having trouble with the age not recalculating every day.  I'm
using
> FMP 4.1 and in the storage options I have the box  checked for "do not
store
> calculation results"  It should still recalculate every day shouldn't it?
>

```
 0

```in article fp_jc.2014\$wY.1358@nwrdny03.gnilink.net, Michael M at
mmyett@hotmail.com wrote on 4/28/04 10:13 PM:

> Your using the best of the two, infact, the Today function has been
> removed from the most current version of FileMaker and has only hung
> around so long for backwards compatability.
>
> Although age calculations tend to be a bit tricky, I don't see any
> reason yours isn't working properly. So I'm a little confused when you
> say doesn't recalculate everyday.
>
> Are there ages that are not updating correctly or were you used to the
> Today function, which recalculated all the records everytime the
> database was opened?
>
> Michael Myett
>
> Tom Ryan wrote:
>> I have a FMP database that keeps track of driver education students.  I'm
>> not knowledgeable in FMP, but I can usually get it to do what I want.
>> Which one of these formulas would work best to calculate age based on birth
>> date and the system date or is there a better one?  I'm using the second one
>>
>> Year(Today) - Year(Birthdate) - If(Today< Date(Month(Birthdate),
>> Day(Birthdate),Year(Today)),1,0)
>>
>> Year(Status(CurrentDate)) - Year(Birthdate) - If(Status(CurrentDate)<
>> Date(Month(Birthdate), Day(Birthdate),Year(Status(CurrentDate))),1,0)
>>
>> I'm also having trouble with the age not recalculating every day.  I'm using
>> FMP 4.1 and in the storage options I have the box  checked for "do not store
>> calculation results"  It should still recalculate every day shouldn't it?
>>
When I say it does not recalculate every day I mean that as a students
birthday comes and goes I find that his/her age has not updated in the
database

```
 0

```in article BCB65E9D.13B05%tomr40@surfbest.net, Tom Ryan at
tomr40@surfbest.net wrote on 4/29/04 5:26 AM:

> Today

I've not tested your calculation for any possible problems, but I would
suggest to changes.

1. Stop using the Today function and start using the Status(CurrentDate)

2. Unstore the Calculation will make it update daily.

HTH

Lee

```
 0

```In article <BCB5CF8C.13AEE%tomr40@surfbest.net>,
Tom Ryan <tomr40@surfbest.net> wrote:

> I have a FMP database that keeps track of driver education students.  I'm
> not knowledgeable in FMP, but I can usually get it to do what I want.
> Which one of these formulas would work best to calculate age based on birth
> date and the system date or is there a better one?  I'm using the second one

Times and dates are nothing more than integers in most (modern) computer
applications.  Times in FM are simply an integer that increments 1 for
each second.  Dates increment by 1 for each day. If you think about them
with these behaviors in mind many of your time and date calculations
will become MUCH easier (and faster).

JR
```
 0

```I'm using FM7 and the second calculation keeps giving me an error - it
highlights STATUS and tells me this "This function cannot be found"!

Can anyone help me out, please?

Thanks,

O.

On Thu, 29 Apr 2004 03:32:16 GMT, "AL Lawrance" <ajlawrance@shaw.ca>
wrote:

>The better calculation is the second one as previously mentioned ... works
>with FM 7.
>
>The only problem in calculating I can think of  is when the date of birth
>has been formatted (e.g., April 4, 1988) ... it has given me problems in the
>past.  Make sure the date of birthday is entered mm/dd/yyyy with NO
>FORMATTING.
>
>If you set the system clock ahead or back you can see the age change.
>Obviously, the only time an age changes is when the birthdate of a student
>crosses over the system date; otherwise, no change in a student's age will
>occur.

```
 0

```I don't have the calculation to refer to, but the big thing is that you
were given an FM6 calculation for use in FM7.

What were STATUS functions are now GET functions.

In many such situations, it is a simple matter of changing STATUS to GET,
but look in the GET FUNCTIONS Help to make sure.

Matt

On 6/21/2005, jack-i wrote:

>
> I'm using FM7 and the second calculation keeps giving me an error - it
> highlights STATUS and tells me this "This function cannot be found"!
>
> Can anyone help me out, please?
>
> Thanks,
>
> O.
>
> On Thu, 29 Apr 2004 03:32:16 GMT, "AL Lawrance" <ajlawrance@shaw.ca>
> wrote:
>
> > The better calculation is the second one as previously mentioned ...
works
> > with FM 7.
> >
> > The only problem in calculating I can think of  is when the date of
birth
> > has been formatted (e.g., April 4, 1988) ... it has given me problems
in the
> > past.  Make sure the date of birthday is entered mm/dd/yyyy with NO
> > FORMATTING.
> >
> > If you set the system clock ahead or back you can see the age change.
> > Obviously, the only time an age changes is when the birthdate of a
student
> > crosses over the system date; otherwise, no change in a student's age
will
> > occur.
```
 0

7 Replies
302 Views

Similar Articles

12/12/2013 9:48:50 AM
[PageSpeed]

Similar Artilces:

calculating age
Friday afternoon question: How do people usually calculate age? For example, I have date of birth (dbirth) and date when a blood sample was taken (DateTaken), both as SAS dates. Two methods I commonly use are: age1=(DateTaken-dbirth)/365.25; age2= (year(DateTaken)-year(dbirth)-1) +(month(DateTaken) > month(dbirth)) +(month(DateTaken)=month(dbirth))*(day(DateTaken) ge day(dbirth)); The first is simple (and sometime I take INT(age1)). The second is what I call 'age in birthdays' --- it is what a person what say their age was, if ask. (Yes, I realise there is a problem i...

Age Calculation in the future
Hello- I've looked at all the age calulation solutions - but I'm a little stumped on how to set this one up. Here is what I need to do. I need to find all the kids in my DB that are currently 11 or 12 years of age AND All the kids who WILL BE 11 on or before Dec 31, 2005. The current kids aren't an issue - but how do I calculate who is 10 now and will have a birthday between tomorrow and 12/31/05 ??? Appreciate any suggestions, john- <jomonto@zeus.kern.org> wrote in message news:1129759962.696003.128220@g14g2000cwa.googlegroups.com... > Hello- > > I've lo...

Re: how to calculate age from dob? #8 1543805
please can someone explain..... when calculating a value as "lumpy" as age, why is such fine precision important ..........? Peter Crawford On Thu, 29 Jul 2004 13:41:55 -0600, Richard Read Allen <peakstat@WISPERTEL.NET> wrote: >I believe that the yrdif function also properly accounts for leap years. >Does anyone know any differently? > >Thanks, > >Richard > >At 03:31 PM 7/29/2004 -0400, Cuthbertson, David wrote: >>To account properly for leap years, use the following macro which return >>age as an integer: >> >>%macro agemac(...

Calculated fields
Is it possible and/or desirable to have calculated fields recalculate when they are viewed and not when their dependent fields change? Is it possible and/or desirable to not store calculated fields? If so, how? I've only used calculated fields that are stored with a record and are only recalculated if the fields it is dependent on change. While this works, it has drawbacks. Storing the result eats memory. A new calculated field in existing records won't calculate until something changes. Batch updates to a Filmmaker server are slowed when recalculation takes place as it is updated...

FM6: any way to abort calculation of a calculated field?
Is there a way to abort the calculation of a calculated field if it is taking too long? E.g a complex calculated field that involves lots of sums and takes hours to run? In article <c2b901fc.0404141003.50748c6d@posting.google.com>, barbecue@afn.org (Bill Mercer) wrote: >Is there a way to abort the calculation of a calculated field if it is >taking too long? E.g a complex calculated field that involves lots of >sums and takes hours to run? Probably not, but if your field is *that* complicated (and your database has *that* many records to calculate), this sounds like a fine exa...

eBay: Age of Empires II Age of Kings
Age of Empires II - Age of Kings http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=8289113781 Low starting bid and NO reserve! Thanks for looking and good gaming! ...

calculator
Hello all, my very first perl program, a calculator that takes formulas; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ## # CALC 1.0 # running: \$perl calc.pl # elmakko Feb 2005 ## use strict; use warnings; my \$delimit_arr = "\n\t++++++++++++\n\n"; my \$argc = scalar(@ARGV); if(\$argc != 1) { print "\n/*\n * usage: perl calc.pl <formula>\n */\n\n"; exit -1; } my \$ans = eval(\$ARGV[0]); system "clear"; banner(); print "\t\$ans \n"; print "\$delimit_arr"; sub banner() { print "\n\...

calculation
Hi. Can awk add numbers with decimals? I mean if I have a file like: 1233 1234 10.02 1233 1234 10.5 1233 1234 10.120 1233 1234 10.0 awk '{print \$3}' give the same result like in a filelike this: 1233 1234 10 1233 1234 10 1233 1234 10 1233 1234 10 Thanks horatiu wrote: > Hi. Can awk add numbers with decimals? I mean if I have a file like: > 1233 1234 10.02 > 1233 1234 10.5 > 1233 1234 10.120 > 1233 1234 10.0 > awk '{print \$3}' give the same result like in a filelike this: > 1233 1234 10 > 1233 1234 10 > 1233 1234 10 > 1233 1234 10 No, it doesn...

MHcHp+, Hardy Cross method to calculate flow rates in piping system for HP49 series calculator
Hi, I am Luis Morales from Chile. I developed a software to calculate flow rates in piping system including pumps, loss coefficients, real and pseudo loops, and two formulas to calculate R resistance coefficient (Hazen-Williams and Darcy-Weisbach). I did it because is an inportant part of my thesis to get the degree of mechanical engineer. You all can get the software and my thesis (it is in spanish but it has an english part) explaning how to use in http://rapidshare.de/files/4401795/MHcHp_.rar.html When you use it, please, send me your comments. Hi Luis, I didn't see it at the link yo...

FA: Ends Soon AGES 4-8 Tivola Oscar Flies into the Mountains AGES 4-8
http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&rd=1&item=7108656231&ssPageName=STRK:MESE:IT -- Find this and more at our fully searchable EBAY shop: http://stores.ebay.co.uk/AUCTI0NST0P For Children's Games, Educational, Language & Recreational Software ...

Form calculator
I have this javascript written form calculator that just adds numbers from blank text fields and enters into a seperate text field the total. What I would like is for this form calculator to include radio buttons, checkbox, and dropdowns. Right now if I include this in this script (I add the number to value="") none of these, except for a simple text field works. Any help would be GREATLY appreciated. Here is the script that I'm using: <html> <head> <title></title> <SCRIPT LANGUAGE="JavaScript"> <!-- function sumIt() { var f = d...

New Calculator -- Where Is It?
Many of the various blurbs about OS X 10.3.6 comment that the Calculator has been significantly updated. I let Software Update do its thing, installing 10.3.6, but it seems that I'm still running the old Calculator -- 3.1 (v3.2). What do I need to do to get the new version? -- James L. Ryan -- TaliesinSoft In article <0001HW.BDC2B7040000EDC1F04075C0@news.dallas.sbcglobal.net>, TaliesinSoft <taliesinsoft@mac.com> wrote: > Many of the various blurbs about OS X 10.3.6 comment that the Calculator has > been significantly updated. I let Software Update do its thing, ...

Hello I'm fairly new to SAS so please be gentle! I have a database for inpatients. One row of data is for one patient including demographics but also diagnoses 1 to 25 and procedures 1 to 20. I want to be able to perform 2 types of actions with resulting database: - determine if and how many times a patient is readmitted within 30, 60 and 90 days - if the patient has a specific diagnosis, find if they have been readmitted within 30 days with another specific diagnosis. Any help is greatly appreciated - thanks. I'll make three recommendations. First, repost and te...

Calculate subnet
Hi all, Anyone know the good website teach to calculate the subnetting? or if you know how to do them, so can you show me the easy way to calculate them? Thanks for your help www.learntosubnet.com ...

Calculation 27864
Hi all, Very new to Filemaker and would appreciate your help. I am creating a book inventory database that keeps a running total by month. I have a field called startstock that I want to automatically pull from the stockend field from the previous month. For example 2004 stock start = 80 January stock end # = 80 February stock start # = 75 (assuming here that we sold some books) I created the following fields: STARTQUANTITIY this is the yearly stock quantity StockEnd StockStart What is the best way to get the stock quantity to automatically fill for the StockStart fo...

calculating width
I have a span that has a width of 25%. I want to use that span as the top of a dialog box that has rounded corners. So, the span itself is broken up into 3 smaller spans, one for the left and right corner images, and one that stretches in between. <span id="dialogTop" style="{width:25%;}"> <span id="dialogTopLeft" style="{width:6px;}"></span> <span id="dialogTopMiddle" style="{width:(25% - 12px ???);}"></span> <span id="dialogTopRight" style="{width:6px;}"></span> ...

calculating a list..
I was about to create an input to this script: http://www.destroydrop.com/javascripts/tree/ basically its an tree structute that can be created, so i thought i would give it a try. If you look at the code you need to generate it similar to this: d.add(0,-1,'My example tree'); d.add(1,0,'Node 1','example01.html'); d.add(2,1,'Node 2','example01.html'); d.add(3,1,'Node 1.1','example01.html'); d.add(4,1,'Node 3','example01.html'); d.add(5,1,'Node 1.1.1','example01.html'); d.add(6,1,'Node 1.1.1.1',&#...

Time Calculations
Does anyone know of a method to compute times as in track & Field? For example, Runner#1 finishes 800m in 2:02.37, Runner #2 finishes in 1:58.6. The metod I've used so far is cumbersome. Multiply 1st number by 60(for minutes), add result to 2nd number(seconds) and and 3rd number(hundreths of a second) to get one total. Results can then be sorted by the Total column. Is there a better way? sfwilson In article <111henpri0dur06@corp.supernews.com>, sfwilson <coach777@megahits.com> wrote: > Does anyone know of a method to compute times as in track & Field? For ...

Calculator Question
I have a new financial calculator, and I want to calculate what a payment would be for a \$25,000 piece of equipment, at 7.5%, over 5 years (60 months). Can someone tell me how to punch in the correct functions to result in the correct payment. I have the PV, N, I, PMT, and FV functions. Thanks! Benny Hi, Use the usual financial formula: VA=VI*(1+r)^N VA is the acquired value that must be found VI is the initial value in your case 25,000 r is the rate, in your case 0.075 N is your period in your case 60 fred. "bennyandthejets" <bennyandthejets@yahoo.com> wrote in mess...

Lightning Calculator
I asked the question, "how do you define arithmetic?", and when I came to an answer I understood math in a new, much clearer way. I also happened upon a method of arithmetic optimization that really speeds up calculations on computers. If you wanted to define mathematics I would first define addition. The simplest way to define addition is to create a function for every number and say f_n(x)=x+n , where n is the number you are preforming addition on and x is the modifying value. The problem with this is it uses addition to define itself, so I decided to write it longhand: f_1(x)...