"AGE in the patient field

For users or potential users.
Post Reply
enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

"AGE in the patient field

Post by enamelrod »

is there there a field for age in the letter merge?
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: "AGE in the patient field

Post by jordansparks »

Use birthdate. Word can easily covert that to an age.
Jordan Sparks, DMD
http://www.opendental.com
enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: "AGE in the patient field

Post by enamelrod »

im a computer idiot and i dont see anywhere in word that will do this
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: "AGE in the patient field

Post by jordansparks »

Well, I thought it did. I can't seem to find it now either.
Jordan Sparks, DMD
http://www.opendental.com
nathansparks
Posts: 172
Joined: Mon Aug 04, 2008 12:39 pm

Re: "AGE in the patient field

Post by nathansparks »

I would try this for age in word, supposing you bring in birth date as BirthDate, I have not tried it, if it does not work, postback (or email you, I emailed this to you also).

I guarantee nothing, but I would say 85% chance it will work, if not I have a typo

{ = INT({ DATE \@ "yyyy" } + { DATE \@ "M" } / 12 +
{ DATE \@ "d" } / 365.25 - { MERGEFIELD BirthDate \@"yyyy" \*Mergeformat }
- { MERGEFIELD BirthDate \@"M" \*Mergeformat } / 12 - { MERGEFIELD BirthDate \@"d" \*Mergeformat } / 365.25) }

cheers
nathan
enamelrod
Posts: 462
Joined: Tue Jul 24, 2007 9:51 am

Re: "AGE in the patient field

Post by enamelrod »

any plans to add an age to the patient field?
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: "AGE in the patient field

Post by jordansparks »

I don't think I've seen it yet in the feature request system.
Jordan Sparks, DMD
http://www.opendental.com
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: "AGE in the patient field

Post by jordansparks »

Done in version 6.8.
Jordan Sparks, DMD
http://www.opendental.com
Post Reply