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/ - 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
Re: Date of Birth question
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/ - 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
Re: Date of Birth question
try this
cfset diff = DateDiff("","4/12/1968",#DateFormat(now(),'dd/mm/')#)
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/ - 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
RE: Date of Birth question
cfset dob = "04-dec-1968"
cfset ageYR = DateDiff('', 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/ - 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
