Community
Showing results for 
Search instead for 
Do you mean 
Reply
Accepted Solution

Code for Calculating Age From Birthday

Highlighted
Administrator
Posts: 4,041
Country: United_Kingdom

Re: Code for Calculating Age From Birthday

Hi evang,

 

Just to confirm, in your original database, you've created two brand new fields using Tools > Define Fields. The new birthday field has the type of "Annual Event" and contains a date in the past. The new Calculated age field is created and the new birthday field is selected to be used for the calculation.

 

Is this correct?

If not please, create two new fields in this manner and set them up as such to test.

Highlighted
New Member
Posts: 7
Country: United States

Re: Code for Calculating Age From Birthday

Gary,

I believe the field has the type of "date". Could this be causing the issue?
Highlighted
Administrator
Posts: 4,041
Country: United_Kingdom

Re: Code for Calculating Age From Birthday

Hi evang,

Sorry, my mistake. Type 'Date' would be correct for Age calculations. 'Annual Event' would be used for things like, days since last birthday.
Is everything else unchanged from above?