You need to sign in to do that
Don't have an account?
Shannu
Laststagechangedate on Opportutnity?
I'm attempting to create a formula field on opportunity called 'Days in Stage' that calculates the difference between the Last Stage Change Date Field and Today.
On opportunity, there is an inherent Laststagechangedate field, which is reflected in the formula field.
As a result, I devised the formula shown below.
TODAY() - Laststagechangedate and it is throwing error as below.
Error: Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime
On opportunity, there is an inherent Laststagechangedate field, which is reflected in the formula field.
As a result, I devised the formula shown below.
TODAY() - Laststagechangedate and it is throwing error as below.
Error: Incorrect parameter type for operator '-'. Expected Number, Date, received DateTime
I dont think you would be able to use Last Stage Change Date field in formula. Check limitation below.
https://ideas.salesforce.com/s/idea/a0B8W00000GdiXqUAJ/last-stage-change-date
However you can create new custom field and store Last Stage Change Date field value and use custom field in formula.
Please mark as Best Answer if above information was helpful.
Thanks,
Your formula is taking a Date Value: TODAY() and you are subracting the value from a Field: LastStageChangeDate
You can only perform that kind of operation if the datatypes are the same, but the LastStageChangeDate is NOT the same datatype as TODAY(), it is a DateTime Value.
So you need to fix that by either replacing TODAY() with NOW() ,
or converting LastStageChangeDate from DateTime to Date, by using a DATEVALUE function like this