Filter by maximum date

Hi,   I am pulling data that includes data from many weekly instances/data cuts. For each record I have fields that tell me the data cut's fiscal year, fiscal period and fiscal week (within the fis...