0

I need to create a formula field that will give the anniversary (based on hire date ) of an employee per year. How can i achieve this? thanks

0

1 Answer 1

1

As you are trying to calculate anniversary based on date . So it is like calculating age using date

IF( NOT( ISBLANK( Birthdate ) ) ,
  IF( DATE( 2000 , MONTH( Birthdate ) , DAY( Birthdate ) ) <= DATE( 2000 , MONTH( TODAY() ) , DAY( TODAY() ) ),
     YEAR (Today()) - YEAR ( Birthdate ),
     YEAR (Today()) - YEAR ( Birthdate ) -1 ),
  null)

use this formula and instead of birth date use your hire date field.

Reference:

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .