+ Start a Discussion
erin ryan 8erin 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
Amit Sinha 39Amit Sinha 39
Yes. It seems the formula should be of Date type. Set it to Date and that should work. Could be a typo on their end.
Abhishek BansalAbhishek Bansal
Hi Erin,

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.

Abhishek Bansal.