[Bug 123905] New: DATEDIFF returns Error:508, and, the problem cannot be understood.

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123905

            Bug ID: 123905
        Issue Type: DEFECT
           Summary: DATEDIFF returns Error:508, and, the problem cannot be
                    understood.
           Product: Calc
           Version: 4.0.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: editing
          Assignee: issues@openoffice.apache.org
          Reporter: camilleri.jon@gmail.com
                CC: issues@openoffice.apache.org

Created attachment 82148
  --> https://issues.apache.org/ooo/attachment.cgi?id=82148&action=edit
Attachment

I am trying to calculate the number of days between two dates:
Cell 
A1: 12/22/1954 or 22/12/1954
A2: =TODAY()
A3: =datediff(B1,A1)

The cell A3 reads Error 508, however I cannot quite understand what is wrong
with my input.

Error documentation at https://wiki.openoffice.org/wiki/Calc_Error_Codes, is
vague.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123905] DATEDIFF returns Error:508, and, the problem cannot be understood.

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123905

Edwin Sharp <el...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |elish@apache.org
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Use same format for dates
Use function DAYS
Use semicolon

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.