[KCFusion] Brain Dead

2002-10-04 Thread Safley, Nicole
I need help solving the easiest of problems.  I have just gone brain dead.  Trying to get the fractional number of months from a persons birth date to the present.  Note:  need mm.dd   Thanks for your help. Nicole L. Safley Database Programmer/Analyst Administrative Systems Project Universit

RE: [KCFusion] Brain Dead

2002-10-04 Thread Matt Jones
Not sure what you are looking for exactly, but datediff would probably work nicely   -Original Message- From: Safley, Nicole [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Brain Dead   I need help solving the easi

RE: [KCFusion] Brain Dead

2002-10-04 Thread Safley, Nicole
Tried datediff using months, but it returns an integer.  Is there a way to get months with days as a fraction? -Original Message-From: Matt Jones [mailto:[EMAIL PROTECTED]]Sent: October 04, 2002 11:16 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Brain Dead Not sure w

RE: [KCFusion] Brain Dead

2002-10-04 Thread Matt Jones
So, you want to know that someones birthday was 1 and 4/31 months ago?   -Original Message- From: Safley, Nicole [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 11:18 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Brain Dead   Tried datediff using months, but it

RE: [KCFusion] Brain Dead

2002-10-04 Thread Matt Jones
This might work for you       #decimaldiff#cfoutput>

RE: [KCFusion] Brain Dead

2002-10-04 Thread Safley, Nicole
I want to know exactly how old someone is represented in years carried to two decimal places.  Example:  I am 30.75 years old -Original Message-From: Matt Jones [mailto:[EMAIL PROTECTED]]Sent: October 04, 2002 11:24 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Brain Dead

RE: [KCFusion] Brain Dead

2002-10-04 Thread Ron Hornbaker
How about datediff using days, and divide by 365.25?   -Ron -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Safley, NicoleSent: Friday, October 04, 2002 11:31 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Brain Dead I want to know ex

RE: [KCFusion] Brain Dead

2002-10-04 Thread Glenn Crocker
So you're 30.75 * 365 days old (ignoring leap years).  Datediff by days & divide by 365, if that's close enough.   -glenn   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Safley, NicoleSent: Friday, October 04, 2002 11:31 AMTo: [EMAIL PROTE