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
