Unable to use datediff function in Apache OpenOffice Calc

Question

I am unable to get a result by using the command =DATEDIFF('dd', '2007-08-01', '2007-09-01') in Apache OpenOffice Calc.

Even using two columns of dates and using the formula =DATEDIFF('dd','A2','B2'), I am unable to find the difference between dates.

How can I fix this?

Answer 1

DATEDIFF seems to be OpenOffice Base/SQL function, not Calc function. It can be used in Calc as Basic macro custom function.

Answer 2

=YEARS(C6;$C$3;0)&" Years, "&((MONTHS(C6;$C$3;0))-(YEARS(C6;$C$3;0)*12))&" Month, "&(ROUNDDOWN((DAYS($C$3;C6))-(YEARS(C6;$C$3;0)*365)-(((MONTHS(C6;$C$3;0))-(YEARS(C6;$C$3;0)*12))*30);0)&" Day")

Note: $C$3 can be replace by =Now()

Answer 3

There's no function named DATEDIFF available from the OpenOffice Calc Date & Time funstions.

Instead, you should use the Calc-specific funtions, for example the DAYS function to calculate the number of days between two dates:

=DAYS("2007-08-01", "2007-09-01")

EDIT: Regarding DATEDIFF: this is a function that's part of the Core SQL:1999 standard (see the overview of date/time sql functions in the SQL Wikibook), so you can use it with most SQL databases (OpenOffice Base, MySQL, PostgreSQL and so on). But you can't use a SQL function natively in Calc.