Comparing Date & Date/Time fields when searching for duplicate cases
You are using Case Merge Premium to detect duplicate cases, and would like to use Date & Date/Time fields as part of your default search criteria. For example, perhaps you're looking narrow down your duplicate results to cases created on the same date or within a specific time range and would like to use the "TODAY()" and "LAST 7 DAYS" functions provided by Salesforce.
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:
In this particular example, we're trying to exclude closed cases from duplicate results, with the exception of those closed within the last 7 days.
While date functions such as LAST 7 DAYS is not supported, a formula checkbox field can be created on the Case to capture this information and then used within the duplicate criteria. Implementation instructions can be found below.
Creating the Checkbox Formula Field
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.