You need to sign in to do that
Don't have an account?
erin ryan 8
Trailhead Date formula exercise
I'm receiving an formula error >Error: Formula result is data type (Date), incompatible with expected data type (Number).
Shouldn't it be a Date formula field? Thanks
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From Setup, enter Accounts in the quick find box and select Accounts | Fields.
Scroll to the Account Custom Fields & Relationships section and click New.
Select Formula and click Next.
In Field Label, enter Future Date. Field Name populates automatically.
Select Number and click Next.
Enter the following formula:
TODAY() + 3
Shouldn't it be a Date formula field? Thanks
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From Setup, enter Accounts in the quick find box and select Accounts | Fields.
Scroll to the Account Custom Fields & Relationships section and click New.
Select Formula and click Next.
In Field Label, enter Future Date. Field Name populates automatically.
Select Number and click Next.
Enter the following formula:
TODAY() + 3
The error thrown by salesforce is completely correct because your formula results in a Date data type and you have selected its return type as Number. So it is incompatible.
Please change your forumla return type to Date and everything will be fine.
Let me knwow if you need more information or any help on this.
Thanks,
Abhishek Bansal.