1 Reply Latest reply on Sep 23, 2013 12:59 PM by philmodjunk

    Portal Filter based on date range...

    AliJones

      Title

      Portal Filter based on date range...

      Post

           I want to filter a portal to where it will only list records where the current date falls between 'start_date' and the 'end_date'. Any suggestions on a calculation I can use?

        • 1. Re: Portal Filter based on date range...
          philmodjunk

               PortalTable::Date > LayoutTable::Start and PortalTable::Date < LayoutTable::End

               this assumes that Date, Start and End are all either fields of type date or calculation fields with "Date" as the result type. You'll need to use your table occurrence and field names in place of mine.

               And there is a second method that works where you set up a list of dates separated by returns from Start to End  in a single field that may also be used--though that is usually set up as a match field in the relationship.