I'm using a portal to display records with dates in a range. I'm attempting to use a global to set the number of days in the range. If I filter using this formula:


Dashboard_Calendar::calDate > Get ( CurrentDate )
and
Dashboard_Calendar::calDate ≤ Get ( CurrentDate ) + 3


the portal correctly shows all events dated in the next three days.


But if I try to use the global instead of the hard-coded number, like this:


Dashboard_Calendar::calDate > Get ( CurrentDate )
and
Dashboard_Calendar::calDate ≤ Get ( CurrentDate ) + Dashboard_Calendar::calDateNextXDays


it does nothing.


What am I doing wrong?

Thanks.

Powered by WPeMatico