Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 Tags
Subject: Calculate length of service in years
Thread ID: 268540 Message ID: 268540 # Views: 35 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, July 13, 2010 7:33:12 AM         
   


Dear Expert,

Please provide a select statement to calculate the ages in years as follows

The age should be in decimals say 1.53 yrs


current_date=13-July-2010

idno date-of-birth age
001 20-04-1960 ___

Thanks

ENTIRE THREAD

Calculate length of service in years Posted by Leonard Trevor @ 7/13/2010 7:33:12 AM
RE: Calculate length of service in years Posted by tushar @ 7/13/2010 7:42:19 AM