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๊ฐ
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?
