 |  |  |  |  |  |  |  |
difference in years between two dates (FileMaker Pro 9)
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
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.
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 5:40 pm. Reason: fixed the problem on my own
In MS Access VBA you can use the DATEDIFF function
If i am helpful, please give me reputation points.
You might want to consider 365.25. Keep in mind that every four years there is an extra day 
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
 |
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Filemaker Pro What the?
- Next Thread: SQL For MS Access?
Views: 2416 | Replies: 3
| Thread Tools | Search this Thread |
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS Access and FileMaker Pro
