Sign Up ›
  • Kelly Campbell 4
  • NEWBIE
  • 10 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
SOLVED
6 replies

subtract contract start date from contract end date

Hey all, This is probably silly but I can't figure it out.

I'm trying to create a formula field (Contract Term in months) to get number (of months) a contract is, by subtracting my Subscription End Date custom date field from my Subscription Start Date custom field.

This isn't working:  DATEVALUE(Pilot_Start_Date__c) - DATEVALUE(Pilot_End_Date__c)
Error: Incorrect argument type for function 'DATEVALUE()'.

Can anybody help?  Thanks a million!

Kelly
SOLVED
6 replies

subtract contract start date from contract end date

Hey all, This is probably silly but I can't figure it out.

I'm trying to create a formula field (Contract Term in months) to get number (of months) a contract is, by subtracting my Subscription End Date custom date field from my Subscription Start Date custom field.

This isn't working:  DATEVALUE(Pilot_Start_Date__c) - DATEVALUE(Pilot_End_Date__c)
Error: Incorrect argument type for function 'DATEVALUE()'.

Can anybody help?  Thanks a million!

Kelly