Playing Favorites: How to Manage Date Conflicts When Some Date Ranges Are Preferred Over Others
Source: Palo Alto Medical Foundation
Data with dates often require reconciling conflicting date ranges. Sometimes a set of consecutive, non-overlapping date ranges needs to be created from a set of overlapping date ranges. This is easy when all date ranges are considered equal. However, if some date ranges are preferred over others, more thought is required. One example is reconciling clinical data and determining disease status from overlapping date ranges of normal and abnormal lab values. If abnormal lab values are of interest, then ranges of abnormal values are preferred over normal values when overlap exists. This paper provides one solution to any number of preferences, demonstrates that it executes in a reasonable time with time trial results, and provides a macro implementation.