RE: [KCFusion] Brain Dead

[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, Nicole Sent: Friday, October 04, 2002 11:31 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Brain Dead 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 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Brain Dead 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 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 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Brain Dead 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 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 University of Missouri-Columbia [EMAIL PROTECTED] (573) 882-6284