----- 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/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)
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().
<cfset dt = "5/1/68">
<cfset m = GetToken(dt, 2, "/")>
<cfset d = GetToken(dt, 1, "/")>
<cfset y = GetToken(dt, 3, "/")>
<cfset dd = CreateDate(y, m, d)>
<cfset age = DateDiff("yyyy", dd, Now())>
<cfoutput>
<pre>
Birthday: #DateFormat(dd, "dd-mmm-yyyy")#
Age: #age#
</pre>
</cfoutput>
Jim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
