Add years to birth date in canvas report/ getting a future date of an employee.

[elnatan2604]

Hello, I would like to know how do I add years from employee date of birth and gets his new date. For example employee was born on 01/01/2000 and I need to know the date that he becomes 67 years old, so the date will be 01/01/2067. How do I get this date (01/01/2067) in canvas reporting?

[nlgro02343]

You are aware SAP is moving towards Stories right (meaning canvas will be replaced by it, potentially end of 2025 already)?

If there is a need to have the correct date in canvas, it could be displayed in the correct way, but it will in fact be a piece of text (which doesn't help for filtering purposes.
Typically, I would first make a calculated column to determine the day, month and year of the date (the function selector allows you to take those for each of the calculated columns)

Then I'd make a 4th one that concatenates the values of those 3 values, separated by what ever icon makes sense (commonly / )