Sign Up ›
  • Salesforce Admin 89
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
3 replies

I need to compare four date fields and display the least date field

IF(
    AND(
        ISBLANK(Date1__c),
        ISBLANK(Date2__c ),
 ISBLANK(Date3__c ),
 ISBLANK(Date4__c )

       ),
    NULL,
    DATE(1900, 01, 01) +
    TODAY()-MIN(
        BLANKVALUE(  Date1__c,  DATE(1900, 01, 01)  ) - DATE(1900, 01, 01),
        BLANKVALUE(Date2__c,DATE(1900, 01, 01)) - DATE(1900, 01, 01),
BLANKVALUE(Date3__c,DATE(1900, 01, 01)) - DATE(1900, 01, 01),
BLANKVALUE(Date4__c,DATE(1900, 01, 01)) - DATE(1900, 01, 01),
    )
)
3 replies

I need to compare four date fields and display the least date field

IF(
    AND(
        ISBLANK(Date1__c),
        ISBLANK(Date2__c ),
 ISBLANK(Date3__c ),
 ISBLANK(Date4__c )

       ),
    NULL,
    DATE(1900, 01, 01) +
    TODAY()-MIN(
        BLANKVALUE(  Date1__c,  DATE(1900, 01, 01)  ) - DATE(1900, 01, 01),
        BLANKVALUE(Date2__c,DATE(1900, 01, 01)) - DATE(1900, 01, 01),
BLANKVALUE(Date3__c,DATE(1900, 01, 01)) - DATE(1900, 01, 01),
BLANKVALUE(Date4__c,DATE(1900, 01, 01)) - DATE(1900, 01, 01),
    )
)