Adding dynamic duration column on report

[manirathore]

I have one report in which user information is there. I want to add one column for the duration(in years and months) the user has been with the company and that should be dynamic.

[Ankur Bawiskar]

@manirathore 

if you are using standing reporting then you can use a function field which stores the difference between now time and sys_created_on

see this link

Function Fields in ServiceNow Reports: Calculate and Display Data on the Fly 

see this gif which helps you

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏