Skip to main content
Topics#Data ManagementPregunta de Wolfgang Red
Wolfgang Red preguntó en #Data Management
7 sept 2017, 10:52

I need a formula, which says, when was the last used day? (account) my problem: the "0" always come out. thx for help

MIN ( 

 

  IF(LastActivityDate > Today (), 0, Today() - LastActivityDate),

 

    IF(Isblank(Max_Opportunity_Created__c), 99999, Now () - Max_Opportunity_Created__c),

 

      IF(Max_Contract_Expiration__c > Today (), 0,

 

       IF(Isblank(Max_Contract_Expiration__c), 99999,Today () - Max_Contract_Expiration__c) 

 

    ))
1 respuesta
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    7 sept 2017, 10:58

    How about this - 

    TODAY() - 
    MIN(
        TODAY() - BLANKVALUE(LastActivityDate,                      DATE(1900, 01, 01)),
        TODAY() - BLANKVALUE(DATEVALUE(Max_Opportunity_Created__c), DATE(1900, 01, 01)),
        TODAY() - BLANKVALUE(Max_Contract_Expiration__c,            DATE(1900, 01, 01))
    )
Escribir una respuesta...
0/9000