AnsweredAssumed Answered

Filter portal by date and status

Question asked by ericmiller on Nov 29, 2017
Latest reply on Nov 29, 2017 by ericmiller

I have a menu layout where I want to get a portal displaying all submissions which have a status of "Submitted", and are older then 30 days.  This way I will have an easy way to look and see which submissions I need to follow up on.

 

Currently I have a portal and trying to set a filter with a formula to do this, but it is not working.  what am I doing wrong?

 

Formula:

menu_SUBMISSIONS::Status = "Submitted" and (menu_SUBMISSIONS::SubDate + 30) < Get ( CurrentDate )

Outcomes