what about replacing '31-DEC-1973' with this cf function
DateAdd('YYYY', -31, now()) Or maybe the output of this function as a var?
then into your Oracle code.
that would return 31 years before today.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.billtracker.org <http://www.billtracker.org>
-----Original Message-----
From: James Watkins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 18, 2001 12:01 PM
To: CF-Talk
Subject: Back counting date
I use the following code to determine if a person is under 30 years old.
Problem is I must remember to update every year. Is there a better way to
count back from the current date 31 years and replace the '31-DEC-1973' hard
code?
<!--- Oracle SQL code --->
WHEN spbpers_birth_date>=to_date('31-DEC-1973','dd-mon-yyyy')
Jim Watkins
Technology Strategist
(706) 835-5871
http://www.ngtcollege.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
