0 Replies Latest reply: Feb 3, 2016 8:30 AM by Rinus Reus RSS

    Max year

    Rinus Reus

      i have a question.

       

       

      We have a table containing, amongst other fields, a property code, a value at a specific date, a date, a month and a year field

      we want to select the value of the PROP_UNIT_ARE field on a date that has been selected in the calender.

      we're using the this statement;  max({$<Year={'>=$(PROP_UNIT_DATE_YEAR)'}>}PROP_UNIT_AREA) 

       

      A sample file is attached.

       

      Anyone have a clue?

       

      Thanks in advance