louy3
asked on
Convert birthdate into age.
Here's what I am using.. Truncate((CurrentDate - {ScheduleAllocations.Birth date}) / 365.25) I see that this works for some.. No errors, but the formula tree does not have a "check" on it?? Hope that makes sense.. thanks in advance..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you try it with the formula from the link I posted:
WhileReadingRecords;
DateVar Birth:= {ScheduleAllocations.Birth date};
DateVar Ann := CurrentDate;
if (Month(Ann) * 100) + Day (Ann) >=(Month(Birth) *100) + Day (Birth)
then Year (Ann) - Year(Birth)
else Year (Ann) - Year(Birth) -1
WhileReadingRecords;
DateVar Birth:= {ScheduleAllocations.Birth
DateVar Ann := CurrentDate;
if (Month(Ann) * 100) + Day (Ann) >=(Month(Birth) *100) + Day (Birth)
then Year (Ann) - Year(Birth)
else Year (Ann) - Year(Birth) -1
Glad i could help
mlmcc
mlmcc
ASKER