Salesforce Developer Community

Sorry in advance for the venting :smileymad:

Trying to create a simple workflow rule to trigger an email alert - Pretty simple right?

Wrong!

AND(ISPICKVAL( Type__c , "Shipment"), Promise_Date__c > TODAY(), Promise_Date__c <> 2009/09/09)

Error: Incorrect parameter for function <>(). Expected Date, received Number

No matter what format I put for the date I get this stupid message "Expected Date, received Number"

I've tried:

2009-09-09

09-09-2009

09,09,2009

2009,09,09

2009/09/09

09/09/2009

So I surround the dates in quotes:

"09/09/2009"

'09/09/2009'

Guess what!

Error: Incorrect parameter for function <>(). Expected Date, received Text

Tried searching in the Help section

Dates, Date formats, date formats in formulas, etc.

No help at all!

Tried searching on all of the different Successforce boards

Guess what! I'm the only person that has ever received this message because it doesn't exist anywhere on any of the sites!

I did find one reference to: Expected DateTime, received Number

But that was of no help because my issue is not with Date vs. DateTime

So back to subject of my message... Why is it so hard to find answers to simple questions...?

I'm praying that it was right under my nose all of the time but I was just too tired to see it. But until then :smileymad: