Filter Portal Records problem using GetAsDate function
I want to filter the records of a portal by dates earlier than a certain date. I have used the following calculation and it works:
Table1::Date_Recorded < GetAsDate("1/1/2012")
However, I'd like the formula to look like this:
Table1::Date_Recorded < Table2::Date_Field
Both fields are formatted as "date", and the "Table2::Date_Field" is global.
I want it this way so that the date can be easily changed in a layout.
What am I doing wrong?