Saved search criteria field compare with another field

Hi Experts,
I have a saved search which sends out emails for missing timesheets to employees every morning. This was working fine as I only used to consider last week’s missing timesheets. I have recently changed the criteria to consider missing timesheets for the last month. This is also working fine but the issue is that I am unable to restrict the records of the employees who have joined during the month. Since NetSuite also shows historical timesheets even before a person’s joining date, I have emails from employees saying that they were not on board during the period. I am trying to fix it but somehow I am not able to use the ‘Criteria’ section to add a check of showing only those records after a person’s joining date. Is there a way I can add a condition where I can check Timesheet Date >= Employee.Hire Date

Thanks

Rookie Asked on November 18, 2020 in Saved Searches.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor