desktop-packages team mailing list archive

[poikiloid <569532@xxxxxxxxxxxxxxxxxx>]

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