filter a portal using week and year
i ve got a table "weekly status" containg : week, year and rate
i created a portal, and i wanna show the max(week,year) from the table "weekly status", i don't think uts possible cuz how u could return the max of
week = 50, year = 2010
week = 15, year = 2011
in the filter option of the portal , i thought about something like date (1;week;year) = max (date(1;week;year)), it makes sence but FileMaker doesn't accept caculations in a Max Function.
ne help !!