Most Recent Instance, filtering out future dates

[BrianJ]

@Juju,

Assuming you are using @Melissa’s awesome Extended Date Table, this should easily address your requirement:

Using The Extended Date Table - ISAFTERTODAY

• Brian