• Ian_M
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

 

IF(ISNULL( End_Date__c ) ,
TEXT((TODAY() - Hire_Date__c)/ 365) & " years",
TEXT((End_Date__c - Hire_Date__c)/ 365) & " years")

 

 

Above is the code I have so far. The only problem is that this potentially shows results such as "3.1234237563223457 years". Is there a way to make the equation give a result such as "3 years 33 days"?


Thank you!