NetSuite - How to Create a Case Saved Search to List Cases Closed Within Specific Number of Days After Created Date

To create a Case Saved Search to list cases with Date Closed within 2 days to 7 days after Created Date:

1. Navigate to Lists > Search > Saved Searches > New

2. Click Case

3. Enter a Search Title

4. Under Criteria > Standard subtab, add the following:

• Status is Closed
• Formula (Numeric)  
• Formula = CASE WHEN (ROUND({closed} - {createddate}) <= 7) THEN 1 ELSE 0 END
• Formula (Numeric) = equal to
• Value = 1
• Formula (Numeric)  
• Formula = CASE WHEN (ROUND({closed} - {createddate}) > 2) THEN 1 ELSE 0 END
• Formula (Numeric) = equal to
• Value = 1

5. Under Results > Columns subtab, add the fields to display in the search result, for example:

·         Number

·         Created Date

·         Date Closed

·         Status

6. Click Save & Run.