Skip to main content
Question

Report consecutive dates

  • May 23, 2023 2:34 PM UTC
  • 0 replies
  • 151 views

I have two tables employees and callouts where employees can report multiple callouts. I need to create a report that shows callouts if they fall within 5 consecutive dates. Need help in figuring this out. Thanks !



------------------------------
JAW WA
------------------------------
This topic has been closed for replies.

  • Qrew Member
  • May 29, 2023 4:24 AM UTC

Might need some more information on what sort of fields you have in the callouts table and how it's used.

Do you mean that you want a report that lists where an employee has 5 separate callout records assigned to them where I am assuming there is a date field of the callout that is used to see if those 5 are consecutive?



------------------------------
Josh Hamilton
------------------------------