+ Start a Discussion
Kimberly AmadorKimberly Amador 

Days between contract end date and today in Formulas and Validation Trail

I keep getting an error message (Field EndDate may not be used in this type of formula) on this Trailhead Challenge and cannot figure out what I am doing wrong, I have tried both number and text formulas and it doesnt seem to give me the choice of simple or advanced formulas, any ideas? My formula is EndDate - TODAY() 
I  have also tried TODAY() - EndDate
Ajay K DubediAjay K Dubedi
Hi Kimberly,

Goto Setup>Customize>Case>Fields>Custom fields & Relationship>Create new>Formula field>Give Label Days Since the Last Update>Choose return type Number and in a formula, editor add this formula.
Account.LastActivityDate  - today()

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Ajay Dubedi
Kimberly AmadorKimberly Amador
Sorry this did not work. I am trying to get the days remaining until a contract ends not days since last activities. 
Kimberly AmadorKimberly Amador
Anyone else experiencing Admin Intermediate Formula Field Challenge not working. The error I get says I cannot use contract End Date as a formula field.