Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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