<cfset dob = "04-dec-1968">
<cfset ageYR = DateDiff('yyyy', dob, NOW())>
<cfset ageMO = DateDiff('m', dob, NOW())>
<cfset ageWK = DateDiff('ww', dob, NOW())>
<cfset ageDY = DateDiff('d', dob, NOW())>
<cfif ageYR LT 2>
<cfset age = ageMO & "m">
<cfif ageMO LT 1>
<cfset age = ageWK & "w">
</cfif>
<cfif ageWK LT 1>
<cfset age = ageDY & "d">
</cfif>
<cfelse>
<cfset age = ageYR & "y">
</cfif>
<cfoutput>
<pre>
Birthday: #dob#
Age: #age#
</pre>
</cfoutput>
this is the code i use.
Alexander Sicular
Technical Director, Information Technology
The Neurological Institute of New York
Columbia Presbyterian Medical Center
212.305.1318
[EMAIL PROTECTED]
-----Original Message-----
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 10:18 PM
To: CF-Talk
Subject: Date of Birth question
Hey guys/gals!
I am currently working on database enabling the www.friendsplus.com.au web
site for a friend using, of course, CF. At the moment it is maintained
manually using Micro$oft FrontPage 2000 - not very efficient.
What I need to do is when a member "Joins" and enters their date of birth
(as a Eurodate formatted date DD/MM/YYYY - it's an Aussie site) to calculate
their age in years based on the current date (Now()) - dynamically.
I nearly had it working except it calculated me as being 33 and not 32 (born
December 4 1968).
Any suggestions would be appreciated. In the meantime I'll get back into it.
All the best.
Peter Tilbrook
Slave of Friends Plus (rowers required)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
