Hi stone,
this might help:
#DateDiff("yyyy",CreateDate(listlast(dob,"/"),listGetAt(dob,2,"/"),listFirst(dob,"/")),NOW())#
if your date is still in the format 31/12/2003
cheers,
Toby
Tuesday, March 18, 2003, 1:50:48 PM, you wrote:
sana> Hi
sana> this is where i have got to now
sana> i use <cfset> to re format the date the USA version then use the date diff but i
get an error it needs 3 funtions but i have 3 funtions#&^$#$%#&^#....
sana> This one should really be a simple one to crack but it got me stumped.
sana> I have users date of birth details save in the database as DOB = 31/12/2003 and
i just want to out put how old they are.
sana> <CFOUTPUT query="allRecord">
sana> <cfset newdob= #DateFormat(dob, "yyyy,mm,dd")#>
sana> #newdob#
sana> #DateDiff("yyyy",CreateDate("newdob"),NOW())#
sana> </cfoutput>
sana> Error Occurred While Processing Request
sana> Error Diagnostic Information
sana> An error occurred while evaluating the expression:
sana> #DateDiff("yyyy",CreateDate("newdob"),NOW())#
sana> Error near line 90, column 2.
sana> The function CreateDate takes 3 arguments(s)
sana> The error occurred while processing an element with a general identifier of
(#DateDiff("yyyy",CreateDate("newdob"),NOW())#), occupying document position (90:1) to
(90:45) in the template file
sana> C:\Documents and Settings\Greg Stone.GREG\My Documents\client coldfusion
workfiles\interact\application\members\members.cfm.
sana> thanks for the help
sana> regards greg
sana> ---
sana> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
sana> To unsubscribe send a blank email to [EMAIL PROTECTED]
sana> MX Downunder AsiaPac DevCon - http://mxdu.com/
---------------------------------------
Life is poetry -
write it in your own words.
---------------------------------------
Toby Tremayne
Technical Team Lead
Code Poet and Zen Master of the Heavy Sleep
Toll Solutions
154 Moray St
Sth Melbourne
VIC 3205
+61 3 9697 2317
0416 048 090
ICQ: 13107913
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
