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

use a formula field in your criteria along the lines of FLOOR({timesheet date}-{employeehiredate}) greater than 0 like this:

Thanks so much, this solved my problem :)