Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Needs review
Created by Guest
Created on May 23, 2024

Search with date range between

We would like to create a save search between a day range


Example: All documents update between -7days and -14days this way we will see only the documents update the week before.

The idea behind is to avoid having overlap between -7 days and -14 days. If we specify only -14 day this search will overlap the -7 day

  • Guest
    Reply
    |
    Jun 19, 2024

    This is already possible with a custom expression.

    $FIELD$ BETWEEN (select DATEADD( DAY,-15,GETDATE())) AND (select DATEADD( DAY,-7,GETDATE()))