You need to sign in to do that
Don't have an account?
Kimberly 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
I have also tried TODAY() - EndDate
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.
Thanks,
Ajay Dubedi