AnsweredAssumed Answered

Calculating Due Expire Date

Question asked by on May 24, 2017
Latest reply on May 24, 2017 by

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.