I am attempting to build a report filter for a custom object which shows contracts in my company. I would like the filter to allow me to show only the contracts which were opened (Open Date) within 30 days BEFORE through 90 days AFTER a Projected Close Date field.

So broken down into logic it is :

Open Date Less Than (Projected Close Date - 30)


Open Date Greater Than (Projected Close Date + 91)

Is it possible to create that filter in reports ?

1 Answer 1


You won't be able to do this in that way. You will need to either create 2 formula fields in the object and use those fields in the report or your users will need to adjust the filters manually by selecting the correct dates.

  • Thank you very much. I had a feeling I would need to do that. I wanted to make sure I wasn't thinking of something. I guess what I'll end up doing is to make the 2 fields, one called 30BeforePromoDate and another 90AfterPromoDate - and make them equal to either "Yes" or "No" - and just use the logic in the two field filters 30Before.. equals Yes or 90After... equals Yes......that's what you're suggesting, right ?
    – Zoom_v
    Commented May 12, 2015 at 15:29
  • 1
    Yes, basically that's it :)
    – PepeFloyd
    Commented May 12, 2015 at 15:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .