wcallman

Age based on birth date calculation and locking the result

Discussion created by wcallman on Jun 1, 2018
Latest reply on Jun 2, 2018 by wcallman

I am using:

Year ( Get ( CurrentDate ) ) - Year ( A1_BirthDate ) - If ( Get ( CurrentDate ) < Date ( Month ( A1_BirthDate ) ; Day ( A1_BirthDate ) ; Year ( Get ( CurrentDate ) ) ); 1 ; 0 )

 

to calculate the age of a person. It works perfectly. I now discovered that the field needs to be locked to the age of the person at the time of registration. My customers' client may be in a program for several years and my client needs to report on the age of the person at time of entry and time of exit.

 

Any insight is greatly appreciated.

 

Bill

Outcomes