I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created on and Modified on for each list item.
So far I have tried the solution presented by MS found here: http://msdn.microsoft.com/en-us/library/bb862071%28v=office.14%29.aspx
However, when I use following code and settings to calculate my column, the system presents me with an error:
with formula setting: may only return date and time.
I tried to change the formula setting to text and number with same code, but that did not work either.
I also tried the other code, that is used for time formats, but that does not work either: