Portal filtering by date - help
For the life of me I can't get this to work.
I am trying to filter portal records according to a global date field. My portal has a field called OrderDate in a table called Orders and the global date field is called gDate in a table called Globals.
Here is my formula for portal filtering
If ( Orders::orderdate = Globals::gDate ; 1 ; 0 )
It returns no rows.
What am I missing?