Comparing Date & Date/Time fields when searching for duplicate cases
Case Merge Premium users may want to narrow down duplicate results based upon the date (or date/time) a case was Created, Closed or otherwise updated. For example, Neat Widgets LLC receives an abundance of cases from their customers often with the exact same (or very similar) email subject. When new cases are opened today, the Duplicate Detector is finding cases that are three weeks old. Neat Widgets LLC is looking for a way to narrow down the duplicate results to cases created in the same week.
Starting in version 3.59, Case Merge Premium introduced two new operators for defining duplicate criteria, "within N days" and "within N hours."
In order for Neat Widgets LLC to narrow down Duplicate Detector results to cases opened in the same week, they'll need to adjust their duplicate criteria following the steps below.
Case Merge Premium does not support the use of date functions such as "TODAY" and "LAST 7 DAYS" when configuring the default duplicate criteria. Administrators attempting to use these functions will encounter the following error:
Please note, this KB article is provided as-is. Customization in regards to the creation of custom fields is not supported under the scope of support provided with the Case Merge Premium application. For further assistance, please contact your Salesforce administrator, Salesforce implementation partner, or your Internet Creations Account Executive to inquire about professional services.