get next round birthday

[aheavy95]

Hi all 
As part of a report im working on, I have to create a calculation for a user's next round birthday.

My bday field is in 'DD/MM/YY’ format. 

For example- if a user's birthdate is 01/11/85 the next round bday column will show 01-11-25 ( when his next round birthday will be)

Thanks in advance

[E_Røse · Accepted solution]

I would try to combine the age function, with the addyears-function. Something like

addyears([date of birth], ceil(age(today(), [date of birth]), 10))

Please like and mark my answer as a solution, if it resolved your issue.

[aheavy95]

That worked
thanks a lot