Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 Tags
Subject: RE: Calculate length of service in years
Thread ID: 268540 Message ID: 268541 # Views: 55 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, July 13, 2010 7:42:19 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

You can try

(date()- DateOfBirth) / 365.25

Regards
Tushar

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