This seems like a very simple question, but I am quite confused. I am using standard Contract object, and I created a formula field Half Year Expiration Date which has a formula of EndDate - 182.5. 182.5 is the total of all days in 6 months (given that contract term is 12 months) based on my estimate.

How do I use this in a report such that all contracts with six months remaining before their expiration dates are displayed?


I think your requirement can be met by using a relative date filter on Contract end date which will save you an extra field. This example will show all contracts that have an end date greater than 6 months from today.

If you want those ending before then you would adjust the filter.


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.