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?
Attribution to: Prady
Possible Suggestion/Solution #1
EDIT :
My bad, it does actually let me create a formula field if both fields are of type date, so TODAY() - Date_Field__c
in a Number formula field seems to compile okay. Check that your date field is not actually DateTime ? And that your Formula field is of type number.
I don't believe you can use mathematical operators on date fields.
You will need to write something like
365*(Year(today()) - year(sdate__c)) + 30*(month(today() - month(sdate__c))) + (day(today())- day(sdate__c))
Attribution to: techtrekker
Possible Suggestion/Solution #2
Can you go back and check your field definitions - is sDate__c definitely a date and your formula is definitely a number formula?
I defined a couple of fields and I was able to use the formula as you would expect TODAY() - initial_date__c
Otherwise surely you are in a world of trouble re-inventing the wheel trying to cope with leap years and month lengths?
Attribution to: Doug B
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/5034