I wanted to have a formula field with difference between a datefield and todays date. The formula field is a number to store the no of days.
The formula that i have is
TODAY() - SDate__c
SDate__c is a Date field.
But when i check syntax it results in
Error: Formula result is data type (Date), incompatible with expected data type (Number).
What am i doing wrong here? OR
How do i get the date difference between todays date and sdate?