AnsweredAssumed Answered

Filter Portal Records problem using GetAsDate function

Question asked by cmspe on May 12, 2012
Latest reply on May 14, 2012 by philmodjunk

Title

Filter Portal Records problem using GetAsDate function

Post

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?

Outcomes