1. Create a formula to find the current code:

    If isNull({ConstituentCode_DateTo}) or {ConstituentCode_DateTo}="" then {ConstituentCode_ShortCode}
 
  • Insert a maximum summary on this formula for the Constituent group