• Sivan Naor
  • NEWBIE
  • 15 Points
  • Member since 2016
  • Database Officer
  • CALM - Campaign Against Living Miserably

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 5
    Replies
Hi all,

I am trying to create a formula that will calculate a certain amount ,according to specific dates (NPSP version). It seems like I have a problem with the date format, since this is the error message I get:
"Error: Incorrect parameter type for operator '>='. Expected Date, received Number"

This is the formula:
IF(npe01__Payment_Date__c >= 2008-01-01 && npe01__Payment_Date__c < 2011-01-01, npe01__Payment_Amount__c*1.25+3.21,  IF(npe01__Payment_Date__c > 2011-01-01, npe01__Payment_Amount__c*1.25, npe01__Payment_Amount__c) )

The Payment Amount date is a date field. Does anyone have any idea regards to how should I type the date correctly?

Any help much appreciated,

Sivan
Hi all,

I am trying to create a formula that will calculate a certain amount ,according to specific dates (NPSP version). It seems like I have a problem with the date format, since this is the error message I get:
"Error: Incorrect parameter type for operator '>='. Expected Date, received Number"

This is the formula:
IF(npe01__Payment_Date__c >= 2008-01-01 && npe01__Payment_Date__c < 2011-01-01, npe01__Payment_Amount__c*1.25+3.21,  IF(npe01__Payment_Date__c > 2011-01-01, npe01__Payment_Amount__c*1.25, npe01__Payment_Amount__c) )

The Payment Amount date is a date field. Does anyone have any idea regards to how should I type the date correctly?

Any help much appreciated,

Sivan
Hello All,

I keep getting this error on this question:

Challenge not yet complete... here's what's wrong: 
An update to an account record failed to update the mailing address fields of all child contact records. Make sure that the process is correct and that it is activated.

Screenshot:
https://www.dropbox.com/s/30lrmgz8zogxulf/Screenshot%202015-03-23%2016.09.38.png?dl=0

Screenshot 2:

https://www.dropbox.com/s/5wrdht63l18591b/Screenshot%202015-03-23%2016.10.57.png?dl=0

I have gone over this many times and I would appreciate any help to get through this challenge!!


Thanks!