Apex Code Development You need to sign in to do that
Don't have an account?
Jude Green 18 only calculate days of age from a date field if close date in future
I want to have a continually updating Age in Days formula field, where it takes the number resulting from (TODAY() - (Age entered Stage2_c) but only when the Close Date is still in the future
It should freeze on the Days count when Close date is in the past.
I cannot get a working CASE or IF formula, I have looked through the various examples. Is this possible please?
I can do a PB or workflow, but these do not fire until an edit occurs.
Thanks for any suggestions
It should freeze on the Days count when Close date is in the past.
I cannot get a working CASE or IF formula, I have looked through the various examples. Is this possible please?
I can do a PB or workflow, but these do not fire until an edit occurs.
Thanks for any suggestions
Try Below Formula
If the Close_Date__c is future date than it's calculate the total days otherwise it's return the 0 value in Days field.
IF( Close_Date__c > Today(), Today() - DOB__c , 0 )
Please Mark It As Best Answer If It Helps
Thank You!