DateValue does not reconize Leap day

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 2.5.0
    • Affects Version/s: 2.3.0
    • Component/s: ZSS Component
    • None

      Using ZK Spreadsheet, datevalue does not appear to handle leap day.

      =DATEVALUE("2-28-2012") returns 40967
      We would expect =DATEVALUE("2-29-2012")to return 40968. Instead, it throws an error.
      =DATEVALUE("2-28") returns 40967
      =DATEVALUE("2-29") returns 10625

            Assignee:
            Unassigned
            Reporter:
            mdavis
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: