I have a table with the fields year, weeknumber, enddate week
I have a variablevmaxyear
In my listbox field weeknumber can be selected and an expression is added : =sum(distinct {<year= {$(vmaxyear)}>enddate_week)
When no selecttion is made, the enddates are correct presented. When a weeknumber is selected however, the date of the selected weeknumber is presented correctly, but all the other dates give 30-12-1899.I can explain why , but I would like to keep the correct dates presented. Is that possible ?
SOLVED: changed the expression to : =sum(distinct { weeknumber=, <year= {$(vmaxyear)}>enddate_week)