Skip to main content
Answered

Upcoming terminations and new hires in one view?


Edda van der Ende
Communicator
Forum|alt.badge.img+14

Hi,

How can I see with one view whose contracts are ending within the next 2 months and simultaneously who are joining in the next 2 months?

Is there a report I can use for this?

Edda

Best answer by HRJoy

Hmm. You will need to remove ‘hire date’ from the Filter section, because it will filter out anyone not joining in that range (hence no visible terminations). So maybe this isn’t quite the report you need after all - you will still see the full employee list and have to filter by both hire and termination date...

View original

7 replies

HRJoy
Communicator
Forum|alt.badge.img+13
  • Communicator
  • 105 replies
  • April 4, 2025

I believe you can use the People List (under ‘Organisation’) to do this, by adding columns to show Hire Dates and Termination dates. I know that’s not a report, but you can save that list once you are happy with the format and just come back to it as and when required.


Edda van der Ende
Communicator
Forum|alt.badge.img+14

Thank you,

Unfortunately, this is not optimal as it gives information on all employees. I would like to see the upcoming 2 months only without needing to export into Excel.


HRJoy
Communicator
Forum|alt.badge.img+13
  • Communicator
  • 105 replies
  • April 7, 2025

The Analytics/Reports function (new version in Beta currently) offers a ‘Hires’ report template.

If you create a new report using that template, add a new ‘termination date’ column, and set the date range (under Filters) to the next two months, you should then see all hires and terminations in the date range specified.


Moe
Community Admin
Forum|alt.badge.img+9
  • Community Admin
  • 181 replies
  • April 8, 2025

Hi ​@Edda van der Ende!

Has ​@HRJoy’s most recent reply answered your question? If so, go ahead and select it as the Best Answer so that other community members can find it!  


Edda van der Ende
Communicator
Forum|alt.badge.img+14

Hi ​@Moe - I haven’t had time to look into this yet :)


Edda van der Ende
Communicator
Forum|alt.badge.img+14

Hi, I tried creating this report, but it doesn’t show the people whose employments are coming to their end. I have checked that there are some employees that have a termination date in their profile within the time range below.

 


HRJoy
Communicator
Forum|alt.badge.img+13
  • Communicator
  • 105 replies
  • Answer
  • April 8, 2025

Hmm. You will need to remove ‘hire date’ from the Filter section, because it will filter out anyone not joining in that range (hence no visible terminations). So maybe this isn’t quite the report you need after all - you will still see the full employee list and have to filter by both hire and termination date...


Your reply