Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
calculating how old a client is from 2 dates 1
- Thread starter willpp
- Start date
-
1
- #2
Use Ken Hamady's age formula:
WhileReadingRecords;
DateVar Birth:= {table.birthdate};
DateVar Ann := {table.registrationdate};
if (Month(Ann) * 100) + Day (Ann) >=(Month(Birth) *100) + Day (Birth)
then Year (Ann) - Year(Birth)
else Year (Ann) - Year(Birth) -1
-LB
WhileReadingRecords;
DateVar Birth:= {table.birthdate};
DateVar Ann := {table.registrationdate};
if (Month(Ann) * 100) + Day (Ann) >=(Month(Birth) *100) + Day (Birth)
then Year (Ann) - Year(Birth)
else Year (Ann) - Year(Birth) -1
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question