Total Number of Days

[#1]

Hi All,

I need to find out the total number of days for which I have data with me.

For example. The earliest entry in my database was made on 1st Jan 2013 and the latest entry is made on 10th Jan 2014. Now I need to find the total number of days between this two values.

[maxgro · Accepted solution]

if you have a date field (d) you can use minus, example

=max(d) - min(d)

to find the number of days

with your 2 dates the result of the  expression 

=date#('10-01-2014', 'DD-MM-YYYY') -  date#('01-01-2013', 'DD-MM-YYYY')

is 374