ProjectWise Design Integration Ideas Portal

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

  • Luc Poulin
  • May 23 2024
  • Needs review
  • Dave Cumming commented
    19 Jun 15:29

    This is already possible with a custom expression.

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