1 Reply Latest reply on Jun 17, 2012 2:51 AM by raybaudi

    Filter portal by time

    AnitaWoods

      Title

      Filter portal by time

      Post

      I have the following calculation in a portal filter that shows related records from the LaborEntry table.  Birth and LaborEntry tables are related by ContactID.

      (LaborEntry::Date & LaborEntry::Time) < (Birth::DOB_baby & Birth::Birthtime)

      I only want records in the portal where LaborEntry::Date and LaborEntry::Time are before Birth::DOB_baby & Birth::Birthtime. If the baby is born at 11:06pm, and there is a LaborEntry record at 11:06pm, I want that entry to appear, but an entry at 11:07pm to not. At present, it will not show a LaborEntry at 11:06pm, but still shows one at 11:35pm, but nothing after midnight (thus, the next day).  I have an inverse portal on another tab of the same layout that has the inverse:

      (LaborEntry::Date & LaborEntry::Time) > (Birth::DOB_baby & Birth::Birthtime)

      That one appears to only be showing records that occur after the day, but doesn't show anything the same day as the birthdate but a later time.  IOW, it will show a record at 12:05am the next day, but won't show something at 11:55pm the same day as the birth.  

      I'm not sure where the calculation for the filter is wrong that it sorta works and sorta doesn't.