다음을 통해 공유

SharePoint 2010: How to Calculate Total Years of Experience in Present Company?

  • 아티클

A request from a client for the total years of experience needs to be displayed/updated without user intervention and to display the information in a SharePoint list. All the other information about users like First Name, Job Title etc., were displayed in the custom list using "Person or Group" type and selecting the relevant "Show field" option. The data about the user is stored in AD but how to get the total years of work experience for the present company?

So we did the following:

  1. Created a custom list and added a column "Joining Date" with datatype as "Date and Time" and selected "Date Only" option.
  2. Created a new calculated column with following formula "=(Created-[Joined Date])/365" with the return data type as number and decimal places to

 

Thanks MeShare and Hemendra Agarwal for valuable suggestions.