Skip to main content
Topics#Data ManagementPergunta de Nancy Wilde
Nancy Wilde perguntou em #Data Management
14 de mai. de 2013, 15:55

I need to compare two date fields and pull in the greater of the two dates.

How can I compare two date fields on a custom object and pull in the greater of the two dates?   For example:

 

02/01/2013 and 03/15/2013, I need to pull in 03/15/2013.
1 resposta
  1. James Jetchick (Rivot Digital)
    14 de mai. de 2013, 16:06
    A formula with return type of Date. The formula should be the following:

     

    IF(Date_Field1__c > Date_Field2__c, Date_Field1__c, Date_Field2__c)
Escrever uma resposta...
0/9000