2 Replies Latest reply on Jul 16, 2014 3:06 PM by lbellino

    Date Calculation for Portal Filter

    mgxdigital

      Title

      Date Calculation for Portal Filter

      Post

      Hello,

       

      I'm needing help on a portal filter.

      I'm wanting to limit a portal based on the creation date of hte records listed in the portal.

      I'd like to limit them to records created 1/1/2012 and newer.

      I've been trying to accomplish this by a calculation but can not get it.

      Any help would be much appreciated.

       

      Thank you,

        • 1. Re: Date Calculation for Portal Filter
          philmodjunk

          Portaltable::Creationdate > Date ( 1 ; 1 ; 2012 )

          or

          PortalTable::Creationdate > getasdate ( "1/1/2012" )

          • 2. Re: Date Calculation for Portal Filter
            lbellino

                 I needed to use this calculation, which works great, but is there a way to write it where that instead of editing the date each year, that this only shows records that are from the past two years? So right now, records would be shown for ones created from 2012 to 2014, but next year, would like to show from 2013 to 2015 and so forth and have it automatically looks for dates for the last two years.And I would also like it to show records that don't list a date.  Hope I'm making sense what I'm trying to do and someone can help. Thanks.