try this
<cfset diff = DateDiff("yyyy","4/12/1968",#DateFormat(now(),'dd/mm/yyyy')#)>
<cfoutput>#diff#</cfoutput>
----- Original Message -----
From: Peter Tilbrook <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 11:18 AM
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
