trying to update a report that show /generates work anniversaries

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
the current report I am updating is sent out during the first of the month showing the employees who have an work anniversaries of the current month. And think the formula below is what filters it.

Month(Today())=Month([Employment Start Date])

what I want to do:

adjust that formula so it shows who has anniversaries the next month.

end result: I am setting the up the subscription to send on the 20th of each month to show the employees who have anniversaries the next month (this way we have a 10 day window to send greeting cards)


Photo of Paul

Paul

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Try this:

Month( AdjustMonth(Today(), 1) ) = Month( [Employment Start Date] )


The "AdjustMonth" function shifts the date by the specified number of months.

So this checks if the month of the [Employment Start Date] matches the current month + 1  (i.e. the next month).