Apex Code Development You need to sign in to do that
Don't have an account?
Xiidaen Custom Object Conditional Date/Age Calculation Help
I'm trying to calculate a custom object's age based on conditional factors, but the formula is giving me fits. I"d appreciate any insights you might have.
I have a custom object and want to create a field called 'Age' that shows the age of the object, but with some conditions.
If the object 'status' picklist = "Accepted / Confirmed" or "Cancelled / Lost" I would like this field to return the last modified date. (ideally the date the status changed from stage history, but that's not a critical point for me)
If not, the age should be Today () - CreatedDate.
I can't seem to get this formula to work, has anyone done anything similar to this?
Thanks!
I acutally got this answered with help from Support (now that I know they can do that, they may get a lot more calls from me!) Here's the formula in case anyone needs it.
CASE(
Req_Status__c , "11. Confirmed by Requirements",
ROUND(LastModifiedDate - CreatedDate, 0), "12. ReqCancelled / Project Lost",
ROUND( LastModifiedDate - CreatedDate, 0), ROUND( Now () - CreatedDate, 0))