I am trying to pull a number (year up to a tenth) in a formula using a date field.
IF(ISBLANK(Pump_End_1st_Rebuild__c),(TODAY()- Ship_Date__c)/365, NULL)
2 answers
The more I think about this, the less it makes sense.
Can you give us examples of Ship Date and what you would expect the formula to return against today's date?
