Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Glenn Nyhan 54Glenn Nyhan 54 

Formula Error - CreatedDate = YEAR(2018)

Hello,

I'm have a problem with a workflow rule using this formula, and am getting an error message. Can somebody point out where I'm going wrong?

CreatedDate  =  YEAR(2018) 
Best Answer chosen by Glenn Nyhan 54
RKSalesforceRKSalesforce
Hi Glenn,

Please create your fornula field like below : 

User-added image
Please mark as best answer if helped for others help.

Regards,
Ramakant

All Answers

RKSalesforceRKSalesforce
Hi Glenn,

Could you please provide your full formula along with Error Message.

Regards,
Ramakant
Glenn Nyhan 54Glenn Nyhan 54
Hello Ramakant,

Here is what I have and the error message;

CreatedDate  =   DATEVALUE(2017)

Error: Incorrect argument type for function 'DATEVALUE()'.

Thanks in advance for the help.

Glenn
Glenn Nyhan 54Glenn Nyhan 54
I want to find and update a field on the Opportunity records where the create date is only for 2017. I am having to mail out tax letters so I need to segregate the opportunity amounts for the tax year 2017. 
RKSalesforceRKSalesforce
Hi Glenn,

Please create your fornula field like below : 

User-added image
Please mark as best answer if helped for others help.

Regards,
Ramakant
This was selected as the best answer
Glenn Nyhan 54Glenn Nyhan 54
Thanks for this information, but I'm not sure what creating this field will do. Can you please clarify?