Need a user report that shows both employee start/entered date and employee deactivated date | Community
Skip to main content
Level 3
December 14, 2022
Solved

Need a user report that shows both employee start/entered date and employee deactivated date

  • December 14, 2022
  • 1 reply
  • 1051 views

I need to run a report that shows both the date an employee was entered if they are an active employee, or the date their account was deactivated if they are no longer using Workfront/left our company.  I don't see an option for "user term date" or something like that, so how can I get a report with this information??

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

If you pull up the API explorer (https://developer.adobe.com/workfront/api-explorer/) and search for user, you'll see one of the available fields is the actual deactivation date. The other one you're after is the entry date. I think the entry date is available on the user report but the deactivation date might not be, so to create it quickly, I'd just use the entry date field as my starter, switch over to text mode, and then everywhere it says "entryDate" I would swap it over to say "actualDeactivationDate".

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
December 14, 2022

If you pull up the API explorer (https://developer.adobe.com/workfront/api-explorer/) and search for user, you'll see one of the available fields is the actual deactivation date. The other one you're after is the entry date. I think the entry date is available on the user report but the deactivation date might not be, so to create it quickly, I'd just use the entry date field as my starter, switch over to text mode, and then everywhere it says "entryDate" I would swap it over to say "actualDeactivationDate".

DeniseCo1Author
Level 3
December 22, 2022

Thank you!  This is exactly what I needed.  I forgot to look at that.  I wish Workfront would make more of these fields available in the interface!