RE: Date of Birth question
Birthday: #dob# Age: #age# 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
Re: Date of Birth question
- Original Message - From: "Peter Tilbrook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 01, 2001 8: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) Does CF recognize the date correctly by using the localization set on the server? I've never had to deal with that, so I don't know. If not, just pull out day, month and year to create a new date, then use DateDiff(). Birthday: #DateFormat(dd, "dd-mmm-")# Age: #age# Jim ~~ 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 #diff# - 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
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
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