Sign Up ›
  • Emma Shank
  • NEWBIE
  • 0 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
4 replies

Add a custom forumula field

Hello,
I'm working on the Adding Business Logic trailhead challenge
https://developer.salesforce.com/trailhead/project/suggestion_box/suggestion_box_4
When entering the advanced formula I copy and paste the formula directly from the challenge

IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate), Implemented_Date__c - DATEVALUE(CreatedDate) )

and receive 

Error: Incorrect parameter type for operator '-'. Expected Number, DateTime, received Date

I'm very new to admin and have no clue why this isn't working. Any help is appreciated! 
4 replies

Add a custom forumula field

Hello,
I'm working on the Adding Business Logic trailhead challenge
https://developer.salesforce.com/trailhead/project/suggestion_box/suggestion_box_4
When entering the advanced formula I copy and paste the formula directly from the challenge

IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate), Implemented_Date__c - DATEVALUE(CreatedDate) )

and receive 

Error: Incorrect parameter type for operator '-'. Expected Number, DateTime, received Date

I'm very new to admin and have no clue why this isn't working. Any help is appreciated! 
4 replies

Add a custom forumula field

Hello,
I'm working on the Adding Business Logic trailhead challenge
https://developer.salesforce.com/trailhead/project/suggestion_box/suggestion_box_4
When entering the advanced formula I copy and paste the formula directly from the challenge

IF(ISBLANK(Implemented_Date__c), TODAY() - DATEVALUE(CreatedDate), Implemented_Date__c - DATEVALUE(CreatedDate) )

and receive 

Error: Incorrect parameter type for operator '-'. Expected Number, DateTime, received Date

I'm very new to admin and have no clue why this isn't working. Any help is appreciated!