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.