search for: dtdistributions

Hello I'm not sure if this is an appropriate use of this mailing list or not, please let me know if it isn't.? I'm struggling to figure out how to merge two data tables based on max effective date logic compared to when a payment occurred.? My dtDistributions DT is a transactional dataset while dtDepartments is a domain data set containing all department names and the effective date of when department name changes have occurred.? For the Bob example below, there was a payment on 2016-01-01 which occurred in H229000.? In 2012, this department was named &...