You need to sign in to do that
Don't have an account?
Taylor Friss
Formula field should return 0, but it is returning -1.
Hi! I've created a formula field to count how long a lead has been under the current owners name.
Note: The formula I've created includes Salesforces default field "LastTransferDate"
Here is the formula:
Today() - LastTransferDate
When looking at a lead record to make sure it worked properly, I noticed it is not calculating properly.
The Last Transfer Date is set as 10/17/2019 which is TODAY'S date and for some reason it is returning -1 instead of 0. Any thoughts?
Note: The formula I've created includes Salesforces default field "LastTransferDate"
Here is the formula:
Today() - LastTransferDate
When looking at a lead record to make sure it worked properly, I noticed it is not calculating properly.
The Last Transfer Date is set as 10/17/2019 which is TODAY'S date and for some reason it is returning -1 instead of 0. Any thoughts?
Error: Incorrect argument type for function 'DATEVALUE()'.
I request you to try this once.
If it's a Date Field then we do not have to write DATEVALUE, instead directly use LastTransferDate.
Thank You,
www.nubeselite.com
Development | Training | Consulting
Please mark this as solution if your problem is solved.