You need to sign in to do that
Don't have an account?
JulieG
Need help on date validation rule!
Hi, I'm having some trouble with a date validation rule - what I want to have happen is, if a user selects "Declined" on the Negotiation Status field, I want them to enter the "Declined Date", which is a date field. Below is my formula and I'm getting an error notice, also below. It looks like that because the Declined Date is a date field, but the system wants text?? I'd appreciate any suggestions....Thanks.
Error: Incorrect parameter for function =(). Expected Date, received Text
AND(
ISPICKVAL(Negotiation_Status__c , "Declined" ), Declined_Date__c
= ""
)
AND(
ISPICKVAL(Negotiation_Status__c , "Declined" ), NOT(ISNULL(Declined_Date__c)))