Hi Philky:
Try this formula:
If totext(CurrentDate,"MM/dd")>=totext({Birth Date},"MM/dd")
then Year(CurrentDate)-Year({Birth Date})
else Year(CurrentDate)-Year({Birth Date})-1
There are other formulas out there that will have you subtract the years and divide by 360 (or some other #) but if accuracy is important, this is the only way to do it as the other methods are not 100% accurate. It looks to see if the the birth month and day has passed, if it has, it subtracts the years, if it hasn't it subtracts the years and minuses 1.
Deb
Hi Philky,
Try this formula.
Int ((Today - {TABLE.Birthdate} / 365.25));
This will subtract the dates and calculate the years by dividing 365.25.
The Int function will prevent the age from rounding up.
Good luck,
Brian
Brian, Your formula gave an error message:
' A Number, or currency amount is required here'
the data type on my field is DateTime
Add comment