1 Reply Latest reply: Jan 14, 2016 3:04 PM by Sunny Talwar RSS

    Display most recent record before a date

      I've got a straight table displaying records within a given date range.  I would like to display ONLY the latest record prior to a user-defned "as of date". To identify this record, tried:

      If(Aggr(NODISTINCT Max({<EFFECTIVE_START_DATE={"<=$(=vAsOfDate)"}>} EFFECTIVE_START_DATE), EMPLOYEE_NUMBER) = EFFECTIVE_START_DATE, 1,null()),

      However, all records return a null.  I'm not sure that my set expression in the MAX function is correct.  Any assistance would be appreciated.