AnsweredAssumed Answered

Portal date filter

Question asked by Matty_1 on Feb 12, 2013
Latest reply on Feb 26, 2013 by philmodjunk

Title

Portal date filter

Post

     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!

Outcomes