difference in years between two dates (FileMaker Pro 9)

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,422 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,406 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 1196 | Replies: 3 | Solved

Previous Post in Thread

Next Post in Thread

•

Join Date: Feb 2008

Posts: 1

Reputation: nicolamoore is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

nicolamoore nicolamoore is offline

Offline

Newbie Poster

difference in years between two dates (FileMaker Pro 9)

Feb 23rd, 2008

I need to calculate the approximate current age in years of patients at a clinic.
We don't have the birthday of all the patients, but we know how old they were when then first registered and we know the date they registered.
I am doing a calculation which returns some strange numbers (e.g., 390, 1271, etc.), which obviously aren't correct.
My calculation goes:
CURRENT AGE = AGE AT REGISTRATION + (CURRENT DATE - DATE OF REGISTRATION).
How to I correct this to make it right?
Thanks.

FIXED IT. Divided the (CURRENT DATE - DATE OF REGISTRATION) by 365 and eureka!
Thanks.

Last edited by nicolamoore : Feb 23rd, 2008 at 4:40 pm. Reason: fixed the problem on my own