Age

[Kuiama Thompson]

Hiya

 

How can I calculate an age by subtracting one date variable from another?

 

Thanks,

 

Kind Regards
Kuiama Thompson
NHS Salford

 

DISCLAIMER:
This email has been scanned for viruses, however we are unable to accept responsibility for any damage caused by the contents. The opinions expressed in this email represent the views of the sender, not Salford PCT unless explicitly stated. If you have received this email in error please notify the sender. The information contained in this email may be subject to public disclosure under the NHS Code of Openness or the Freedom of Information Act 2000. Unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed.

[Jarrod Teo-2]

Hi Kuiama Thompson,

You can try the following.

COMPUTE age = (DATEDIFF(date2n,date1n,"years")).
EXECUTE .

Please note that date2n=current date and date1n=date of birth.

regards
Dorraj Oet

---

Date: Wed, 10 Mar 2010 09:07:08 +0000
From: [hidden email]
Subject: Age
To: [hidden email]

Hiya

 

How can I calculate an age by subtracting one date variable from another?

 

Thanks,

 

Kind Regards
Kuiama Thompson
NHS Salford

 

DISCLAIMER:
This email has been scanned for viruses, however we are unable to accept responsibility for any damage caused by the contents. The opinions expressed in this email represent the views of the sender, not Salford PCT unless explicitly stated. If you have received this email in error please notify the sender. The information contained in this email may be subject to public disclosure under the NHS Code of Openness or the Freedom of Information Act 2000. Unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed.

---

Hotmail: Trusted email with powerful SPAM protection. Sign up now.

[Lemon, John S.]

Look at 'Transform' - 'Date and Time' wizard for this

Best wishes

John S. Lemon
Student Liaison Officer
Directorate of Information Technology - DIT
University of Aberdeen
Tel: [phone]

---

From: Kuiama Thompson <[hidden email]>
Sent: 10 March 2010 09:07
To: [hidden email] <[hidden email]>
Subject: Age

Hiya

 

How can I calculate an age by subtracting one date variable from another?

 

Thanks,

 

Kind Regards
Kuiama Thompson
NHS Salford

 

DISCLAIMER:
This email has been scanned for viruses, however we are unable to accept responsibility for any damage caused by the contents. The opinions expressed in this email represent the views of the sender, not Salford PCT unless explicitly stated. If you have received this email in error please notify the sender. The information contained in this email may be subject to public disclosure under the NHS Code of Openness or the Freedom of Information Act 2000. Unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed.

The University of Aberdeen is a charity registered in Scotland, No SC013683.