2 Replies Latest reply on Oct 20, 2012 12:49 PM by FMNewbie

    Display records in a portal that are between two timestamps

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