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

    Calculating Due Expire Date


      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.