Computing age from a date

[shastamatt]

Hello Everyone,

I understand how to compute the age from the date of birth on a single record.


<cfset pat_age=#datediff('yyyy',DateOfBirth,TreatmentDate )#>

I have a table which holds of which has a date of precedure and other fields.
I have another table which will give the Date Of Birth. How can I determine
the age of a person at a date and then insert into the List I need to output.

<cfquery datasource="#ds#" name="getprocedurelist">
SELECT *
FROM tbltreatmentlist
WHERE TreatmentListclientID=#session.clientID#
</cfquery>

<cfquery datasource="#DS#" name="getPatientDOB">
SELECT PATBirthDate
From tblPatientInformation
</cfquery>

<cfquery datasource="#DS#" name="getClientDOB">
SELECT BirthDate
From tblClientInformation
</cfquery>

<cfif getpatientDOB.recordCount IS 0>
<cfset DateOfBirth=#GetPatientDOB.patBirthdate#>
<cfelse>
<cfset DateOfBirth=#GetclientDOB.Birthdate#>
</cfif>

and the output;

<tr>
<th>age</th>
<tH>date</tH>
<th>doctor</th>
<th>Procedure type/description</th>
<th>Marked?</th>
</tr>
<tr>
<td><!---get the age at treatment---></td>
<td><cfif session.usertype IS 1><input type="text" name="ProcedureDate"
<cfif action IS "change">
value="#dateformat(ProcedureDate,"mm/dd/yyyy")#"</cfif>><cfelse>#dateformat(Proc
edureDate,"mm/dd/yyyy")#|</cfif></td>
<td><input type="text" name="Doctor" <cfif action IS
"change">value="#doctor#"</cfif>></td>
<td><input type="text" name="Description" <cfif action IS "change">
value="#Description#"</cfif>></td>
<td><input type="text" name="Marked" <cfif action IS
"change">value="#Marked#"</cfif>></td>
</tr>
</cfoutput>
<cfelse>
<tr>
<td colspan="5">There are no procedures entered yet.</td>
</tr>

</cfif>

As you can clearly see....I am lost..

Thanks for your help

[BSterner]

I'm assuming you're looping throught the 'getprocedurelist' query to output the
information. So, you just calculate the age at each iteration of your query
output loop.

================================================== =========
<cfquery datasource="#ds#" name="getprocedurelist">
SELECT *
FROM tbltreatmentlist
WHERE TreatmentListclientID=#session.clientID#
</cfquery>

<cfquery datasource="#DS#" name="getPatientDOB">
SELECT PATBirthDate
From tblPatientInformation
</cfquery>

<cfquery datasource="#DS#" name="getClientDOB">
SELECT BirthDate
From tblClientInformation
</cfquery>

<cfif getpatientDOB.recordCount IS 0>
<cfset DateOfBirth=#GetPatientDOB.patBirthdate#>
<cfelse>
<cfset DateOfBirth=#GetclientDOB.Birthdate#>
</cfif>

<!--- Output ages at time of treatment --->
<cfoutput query="getprocedurelist">
<cfset pat_age = DateDiff('yyyy', variables.DateOfBirth,
getProcgetprocedurelistedureList.TreatmentDate)>
My age at the time of treatment was: #pat_age#<br />
</cfoutput>
================================================== =========

Either that or you could just use the 'datediff' function in your
'getprocedurelist' SQL statement so it's returning it as a query column.
Personally, I'd opt for the latter.