• Cassie Bounyavong
  • NEWBIE
  • 10 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hi, I am working on the formula below to check for a date in a date field and get this error.  The "" in the formula is highlighted when I check syntax.

Error: Incorrect parameter type for operator '<>'. Expected Date, received Text

IF(Date(Project__r.Hold_Start_Date__c <>"", Project__r.Hold_End_Date__c =""),"On Hold", "")

Would appreciate any help with the correction for this formula, thanks!!
Hi, I am working on the formula below to check for a date in a date field and get this error.  The "" in the formula is highlighted when I check syntax.

Error: Incorrect parameter type for operator '<>'. Expected Date, received Text

IF(Date(Project__r.Hold_Start_Date__c <>"", Project__r.Hold_End_Date__c =""),"On Hold", "")

Would appreciate any help with the correction for this formula, thanks!!