AnsweredAssumed Answered

filter a portal using week and year

Question asked by Kays on May 12, 2011
Latest reply on May 12, 2011 by philmodjunk

Title

filter a portal using week and year

Post

heyy,

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

and

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 !!

K|Z 

Outcomes