Explore the community Forums CourseMill CourseMill Questions and Answers Advanced Reports: 90 days after hire date

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #351682 Score: 0
    Profile photo of Jennifer Mohr
    Jennifer Mohr
    Member
    beginner
    intermediate
    friend finder
    picture perfect
    profile
    curious george
    wise owl
    contributor
    @jmohr4076

    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!

    #352582 Score: 0
    Profile photo of Jennifer Valley
    Jennifer Valley
    Moderator
    contributor
    beginner
    friend finder
    advanced
    lectora beginner
    verified member
    wise owl
    profile
    picture perfect
    curious george
    94 pts
    @jvalley4735

    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!

    #352611 Score: 0
    Profile photo of Jennifer Mohr
    Jennifer Mohr
    Member
    beginner
    intermediate
    friend finder
    picture perfect
    profile
    curious george
    wise owl
    contributor
    @jmohr4076

    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. 🙂

    #352613 Score: 0
    Profile photo of Jennifer Valley
    Jennifer Valley
    Moderator
    contributor
    beginner
    friend finder
    advanced
    lectora beginner
    verified member
    wise owl
    profile
    picture perfect
    curious george
    94 pts
    @jvalley4735

    Awesome! Thanks for sharing 🙂

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.