Advanced Reports: 90 days after hire date

jmohr4076
jmohr4076 Community Member Posts: 32 ☆ Roadie ☆
Hello friends!

Has anyone been able to crack the code on setting up an advanced report that will pull all employees whose hire date is a certain amount of days prior to the current date?  We are trying to keep track of employees who have been with the company for 90 days and 180 days so we can set up course enrollment to take place.  Being able to do this would save our team hours each week.  Any help would be greatly appreciated!

Thanks a ton!

Comments

  • jvalley4735
    jvalley4735 Community Member Posts: 1,357
    Not yet. But we do have this on our enhancement list because many have asked for this. I think it would be a great enhancement to CourseMill as well!
  • jmohr4076
    jmohr4076 Community Member Posts: 32 ☆ Roadie ☆
    Thank you for the update, Jennifer!

    I actually found a fix that you may want to share with others.  Within the filters, if you add a simple condition with the Property being "Hire Date", Condition being "On", then enter TODAY-90 into the Literal field...you will be able to pull anyone whose hire date was 90 days ago.  Make sure there's no spaces in the literal field. To pull people whose hire date was 180 days ago, change the 90 to 180.

    We then had our IT team upload the csv file to automatically enroll people each morning if they appear on the report. Plus, I turned on the enrollment notification in Coursemill.  So there's literally no manual work for us in regards to this task anymore. :)
  • jvalley4735
    jvalley4735 Community Member Posts: 1,357
    Awesome! Thanks for sharing :)