Portal date filter
I'm trying to filter out any records with an effective date in the future, would this not be as simply as turning the portal filter function on and having the following?
Salary History_Personnel Records::Effective Date ≤ Get ( CurrentDate )
For some reason it's not working, I thought that maybe portal filter could not evaluate get functions and so I also tried setting up a script trigger onRecordLoad to get the current date and set a global variable and swapped out "Get (CurrentDate)" with $$CurrentDate in my calculation and it still doesn't work.
Any help would be greatly appreciated!