4 Replies Latest reply on May 14, 2012 6:12 AM by philmodjunk

    Filter Portal Records problem using GetAsDate function

    cmspe

      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?