Report consecutive dates
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 thi...
Forum Discussion
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
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThis can be done using Formula Queries. Can you tell us if there could be more than one call out on a particular day? That would affect how the formula query would be written.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I tried using this, only half of my job is accomplished. it does list the dates, but i need to filter in the report as in the report should show only employees that have consecutive call outs.
------------------------------
JAW WA
------------------------------
