Skip to main content
Question

Report consecutive dates

  • May 23, 2023
  • 0 replies
  • 74 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.

    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
    ------------------------------
    Terms & ConditionsAccessibility statement