function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SaltinSaltin 

Given Date field, return Yes/No

Hi,

 

I have a field "support termination" which is a date field. What I'd like is to build a second field "Supported" and have it show yes/now or true/false based on the date in "support termination". If the support termination date is in the future, then return yes (or true). If it is in the past, then return no (or false). I would also like to account for situations where no date is in "support termination" and return no (or false).

Thanks for any help you might provide. I am a rookie with formulas.

shillyershillyer

Make a formula field of type Text with this formula:

 

 

IF( Support_Termination__c >= TODAY(), "YES", "NO")

 

Hope that helps,

Sati

 

Message Edited by shillyer on 12-14-2009 01:44 PM
SaltinSaltin

That's it. Thanks alot. When I look at it, it seems so obvious!