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?