if you want a lazy answer read the follwoing.
Just subtract 1 from your current answer.
Xing
----- Original Message -----
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 7:18 PM
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
