Skip to main content
Topics#Data ManagementDonne Kerestic 的问题
Donne Kerestic 提问于 #Data Management
2013年6月22日 15:49

Comparing to Date Fields

I am trying to create an IF statement that sets a field to Yes if the last activity date is greater than the Created Date.  I have tried adding DATEVALUE and DATETIMEVALUE to eliminate the error I am getting.  Neither has worked.

 

This is used in a Workflow rule to determine if a User has responded to a lead since the last interaction the customer has had on our website.

 

IF(

 

Lead__r.LastActivityDate >=

 

CreatedDate,"Yes","No")

 

Error: Incorrect parameter type for operator '>='. Expected Date, received DateTime
6 个回答
  1. Rhonda Ross (Aristotle)
    2013年6月22日 17:52
    Use this:

     

    IF(

     

    Lead__r.LastActivityDate >=

     

    DATEVALUE(CreatedDate),"Yes","No")

撰写回答...
0/9000