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

    Max year

      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