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