AnsweredAssumed Answered

Calculating Due Expire Date

Question asked by ikimuhammed@gmail.com on May 24, 2017
Latest reply on May 24, 2017 by 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.

Outcomes