• sgamc
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies

I have a formula field that calculates a date.

I have a picklist field with numbers (representing number of days).

 

I need a formula that lets me take the date - days and return a date.

 

This simple formula did not work:

Service_End_Date__c - Cancellation_Notice__c

as it returned this error on the Cancellation_Notice_c (picklist) field:

Error: Incorrect parameter for function -(). Expected number, date, datetime, received text.

 

  • June 25, 2009
  • Like
  • 0

I have a formula field that calculates a date.

I have a picklist field with numbers (representing number of days).

 

I need a formula that lets me take the date - days and return a date.

 

This simple formula did not work:

Service_End_Date__c - Cancellation_Notice__c

as it returned this error on the Cancellation_Notice_c (picklist) field:

Error: Incorrect parameter for function -(). Expected number, date, datetime, received text.

 

  • June 25, 2009
  • Like
  • 0