In particular, the solution is that, if you are putting dates DIRECTLY into the years function, you must put it in QUOTES in the format "YYYY- MM-DD"
-- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/569532 Title: Date strings not interpreted as dates by the YEARS function Status in libreoffice package in Ubuntu: Invalid Status in openoffice.org package in Ubuntu: Invalid Bug description: Binary package hint: openoffice.org OpenOffice.org 3.2.0 (OOO320m12 (Build:9483)) ooo-build 3.2.0.10, Debian 1:3.2.0-7ubuntu4 Ubuntu 10.04 LTS While =YEARS(DATE(1999,9,13), TODAY(), 0) and =YEARS(B1, TODAY(), 0) produce the correct result (if B1 contains 13/9/1999), =YEARS("13/09/1999", TODAY, 0) gives an error: #VALUE! So it appears that, at least for the YEARS function, strings containing dates are not properly interpreted as dates. This bug is being filed after confirming the problem described in question 108301 at Launchpad Answers: https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/108301 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/569532/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
