"AGE in the patient field
"AGE in the patient field
is there there a field for age in the letter merge?
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: "AGE in the patient field
Use birthdate. Word can easily covert that to an age.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
Re: "AGE in the patient field
im a computer idiot and i dont see anywhere in word that will do this
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: "AGE in the patient field
Well, I thought it did. I can't seem to find it now either.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
-
- Posts: 172
- Joined: Mon Aug 04, 2008 12:39 pm
Re: "AGE in the patient field
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
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
Re: "AGE in the patient field
any plans to add an age to the patient field?
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: "AGE in the patient field
I don't think I've seen it yet in the feature request system.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact: