I currently have a Formula that is working great:
IF(
ISBLANK(MB_Confirmation_Date__c),
NULL,
BLANKVALUE( MB_magento_first_order_date__c , TODAY() )
- MB_Confirmation_Date__c
)
However, I need to update this to add 1 elemetn:
- If MB Activation Date AND
- MB First Order Date - New AND
- # of MB Orders - New ARE NOT BLANK
- First Order Date -
- #Sales CloudNEW (MINUS) MB Activation Date
15 Antworten
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Ok then, is this better?
IF( AND(NOT(ISBLANK(MB_Confirmation_Date__c)), ISBLANK(MB_magento_first_order_date__c)),
TODAY()-MB_Confirmation_Date__c,
IF(
AND(
NOT(ISBLANK(MB_Confirmation_Date__c)), NOT(ISBLANK(MB_magento_first_order_date__c)), NOT(ISBLANK(MB_number_of_magento_orders__c))),
MB_magento_first_order_date__c-MB_Confirmation_Date__c, NULL))
