[cfaussie] RE: Date difference and create date and date format AGE today

[stone]

Hi this is where i have got to now   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#&^$#$%#&^#....   This one should really be a simple one to crack but it got me stumped.   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. <CFOUTPUT query="allRecord"> <cfset newdob= #DateFormat(dob, "yyyy,mm,dd")#> #newdob# #DateDiff("yyyy",CreateDate("newdob"),NOW())# </cfoutput> Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: #DateDiff("yyyy",CreateDate("newdob"),NOW())# Error near line 90, column 2. The function CreateDate takes 3 arguments(s) 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 C:\Documents and Settings\Greg Stone.GREG\My Documents\client coldfusion workfiles\interact\application\members\members.cfm. thanks for the help regards greg --- 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/