3 Replies Latest reply on May 24, 2017 7:03 AM by ikimuhammed@gmail.com

    Calculating Due Expire Date

    ikimuhammed@gmail.com

      Hello Community,

       

      I would like some help with making portal only show quotes which due expire in next 30 days.

       

      I have a portal which shows all the quotes. I have a ExpiryDate field in quotes table. I would portal to show quotes which only are due to expire in next 30 days.

       

      So for I've done this but neither of them worked.

       

      I checked the portal filter checkbox in portal setting.

       

      ExpiryDate >= ( Get(CurrentDate) -30 )

       

       

      and I also tried this

       

      ExpiryDate <=  Get(CurrentDate) =30.

       

      My ExpiryDate field is formatted as dd/mm/yyyy

       

      How I can make portal to show records which are due to expire in next 30 days.

       

      Thank you.