AnsweredAssumed Answered

Display records in a portal that are between two timestamps

Question asked by FMNewbie on Oct 20, 2012
Latest reply on Oct 20, 2012 by FMNewbie

Title

Display records in a portal that are between two timestamps

Post

     Hi folks...

     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... 

Outcomes