Skip to main content
Topics#Data ManagementDonne Kerestic의 질문
Donne Kerestic 님이 #Data Management에 질문했습니다
2013년 6월 22일 오후 3: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일 오후 5:52
    Use this:

     

    IF(

     

    Lead__r.LastActivityDate >=

     

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

답변을 작성하세요...
0/9000