You need to sign in to do that
Don't have an account?
Saltin
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.
Make a formula field of type Text with this formula:
IF( Support_Termination__c >= TODAY(), "YES", "NO")
Sati
That's it. Thanks alot. When I look at it, it seems so obvious!