Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-149

DateValue does not reconize Leap day

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2.5.0
    • 2.3.0
    • 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

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

              Created:
              Updated:
              Resolved: