Skip to main content
Question

Monthly Hire Date Reminders

  • April 30, 2020
  • 0 replies
  • 13 views

I table which lists my employees, and contains each of their hire dates. I want an automated email that sends a monthly report that contains all employees who's hire date falls within the following month. This will serve as a reminder for my leaders to complete the employees' annual performance appraisals.

Is this possible??

------------------------------
Chris Duarte
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You can make a formula checkbox field called [Anniversary is Next Month?]

with a formula of 

Month([Hire Date]) = Month(AdjustMonth(Today(),1))

and filter a report where that is checked.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------