Recalculating Age when opening report

[Gavin]

Hello.

I am trying to create a report that shows all members names,
birthdates and ages, but I am not sure how to recalculate the member
ages upon opening the report. The age is calculate based on the date
of birth and the date the record was entered. However, if I am opening
the report 3 years from when the member was entered into the system,
the age is 3 years younger than it should be.

Any ideas???


Thanks,
Gavin

[AlexV]

Post by Gavin
Hello.
I am trying to create a report that shows all members names,
birthdates and ages, but I am not sure how to recalculate the member
ages upon opening the report. The age is calculate based on the date
of birth and the date the record was entered. However, if I am opening
the report 3 years from when the member was entered into the system,
the age is 3 years younger than it should be.
Any ideas???

I think the only way to do it would be to write a program that will generate
report instances on demand. In that program you will have to calculate the
age based on current date and both dates. The report instance should be of
course dated to make it clear when the age was calculated.