Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
fsiddiq3 Hello,
I am trying to create a workflow with a field update that basically combines the month of the current date and the year of the current date. I have the field set up as a number, and this is the formula I am using. For some reason I am getting an error message. Below is the formula, what am I doing wrong? Any help is appreciated, thanks!
MONTH(TODAY()) & "" & YEAR(TODAY())
All Answers
The problem is that you're trying to perform the & operation, which operates on text, on variables that are numbers. To fix this, the easiest way would be to convert each aspect to text:
TEXT(MONTH(TODAY())) & "" & TEXT(YEAR(TODAY()))
The formula will output text instead of number, but for your purposes (you probably wouldn't sort by this value if you're putting the month first) this should work fine.