Personally I don't trust the date format 31/12/2003 whenever I see it I
manually change it to 2003-12-31 which is a format I have never had trouble
with (or just avoid it in the first place). May seem like overkill but as
far as I'm concerned its worth it. You never get apps tripping over and
saying - "thats not a date" or confusing it with an american date format, it
sorts properly & is valid as an ODBC dateformat.
Go through the process of:
<cfset day = listgetat(dob,1,'/')>
<cfset month = listgetat(dob,2,'/')>
<cfset year = listgetat(dob,3,'/')>
<cfset newDate = createdate(year,month,day)>
or even
<cfset day = listgetat(dob,1,'/')>
<cfset month = listgetat(dob,2,'/')>
<cfset year = listgetat(dob,3,'/')>
<cfset newDate = "#year#-#month#-#day#">
and you should have to worry about dates anymore.
However your error:
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while evaluating the expression:
#DateDiff("yyyy",CreateDate("newdob"),NOW())#
Is probably because of the quotes around the "newdob". Either use "#newdob#"
or just don't quote it.
Cheers
Mark
______________
Mark Stanton
Web Production
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
www.gruden.com
---
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/
