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?
wkaik Hi Everyone,
I am trying to create a formula to take a future date and substract it from the current date. When stracting dates it say it expects a number as the second value. Does anyone have any ideas.
Thanks,
BK
What are the dates you're using. You have to be careful if your mixing date/time field with date fields. Since your formula is of type "number" it's expecting numbers as the values, but since you're using dates that's the issue.
However use date to number function datevalue. Here is an example of a formula type number where I use two dates.
datevalue(Solution_Provided__c) - datevalue(CreatedDate)