Skip to main content
Topics#Data ManagementNancy Wilde 的问题
Nancy Wilde 提问于 #Data Management
2013年5月14日 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 个回答
  1. James Jetchick (Rivot Digital)
    2013年5月14日 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)
撰写回答...
0/9000