Display records in a portal that are between two timestamps
I have one table called SHIFTS with fields that track information about shifts in the workplace from one day to the next. In another table called CALLS I have fields that track information about calls received on the various shifts. The two tables are related by a ::DATE field. ( SHIFTS::DATE = CALLS::DATE ).
On a layout for SHIFTS I have a portal that shows related records from CALLS (i.e. all the calls received for that shift.) This all works fine except that, because I have it related by the DATE fields, the portal shows all the calls received in that 24-hour period.
I'd like to have the portal display only calls received during a particular shift - i.e., between two timestamps ( ::SHIFTSTART and ::SHIFTEND ) but I'm not sure how to go about this.
Is there a way to do this?? Thanks in advance...