1 of 1 people found this helpful
Have you checked the Field Type you are using for Date Bought, Date Sold, and Days Held?
Date Bought and Date Sold should be set as Date Fields. If they are set to Text fields [which still accepts dates, and is the default Type when adding a field], you'll find the Days Held field will be large numbers.
E.g. Should be:
Date Brought = 26/11/2015
Date Sold = 27/02/2016
Days = 93
But if Date Brought and Date Sold are Text, then Days will equal 27,022,016 - 26,112,015, giving you a total of 910,001. In other words, the Date separator gets ignored.
I used a number field instead of Date Field. Thanks for the reply. Very helpful and it works