function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KIBLKIBL 

Current Month + 3 Months

I have the following formula to return True if the Close date is in the current month or the next 3 month but it doesn't take into account the Year.   What do I add to make sure the Close date is in the same year as Today?

 

IF ( OR
(MONTH( CloseDate ) = MONTH(TODAY()),
(Month(CloseDate) = Month(Today()) + 1),
(Month(CloseDate) = Month(Today()) + 2),
(Month(CloseDate) = Month(Today()) + 3)),
"True", "False")

Steve :-/Steve :-/

Does it have to be the literal "Month" or would TODAY () + 90 work?
KIBLKIBL

It has to be the literal month. 
Steve :-/Steve :-/

Okay that's gonna be tricky for November and December, lemme give it a shot...