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. With the help of a simple formula field, Case Merge Premium can handle this business case with ease.
In order for Neat Widgets LLC to narrow down their Duplicate Detector results to cases opened in the same week, they'll need to perform the following steps.
1. Create a Checkbox Formula Field
At this time, 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:
As a workaround, please follow the steps outlined above in regards to first creating a formula field on Case.
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.